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 *******
MVDBA (Mike Vessey)
February 3, 2020 at 11:33 am
how many records in the table ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply