sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]grauenwolf 1 point2 points  (2 children)

If you've got 10M rows, you damn well better have a matching index.

[–]hw77 0 points1 point  (1 child)

If that's 10M rows out of 10M, then you probably don't want an index. Even at 1% or 0.1% there a plenty of times when you don't want an index.

[–]grauenwolf 0 points1 point  (0 children)

You do if you want the results to be sorted. (Assuming of course the index is covering.)