Hi silver subie,
Thank you for posting query in Microsoft Q&A platform.
Performance of query depends on lot of parameters. I would encourage you to consider checking below two links and see which can fit in your case to increase performance.
Hope this helps. Please let me know how it goes and if any further queries.
Please consider hitting
Accept Answer button. Accepted answers help community as well.