February 3, 2020 at 2:35 am
I notice some slowness on a select statement whenever it's selecting top n rows.
Is there anyway to improve it? Query seems to execute faster if I just issue select * instead of select top n rows.
February 3, 2020 at 9:13 am
your query is most likely doing a costly sort operation etc, do you have an actual execution plan? also can you provide data structure and indexes for the table
***The first step is always the hardest *******
February 3, 2020 at 11:33 am
how many records in the table ?
MVDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy