Do I need to rebuild SQL Server database indexes?

Question

I used the built-in performance tuning tool and created indexes for my database. Since then I have changed some queries from "select top 10 ..." to "select top 50".

My question is: do I need to rebuild SQL Server database indexes?

Answer 1

You do not need to rebuild indexes if all you changed is top 10 for top 50. Queries are exactly equal in terms of execution (and therefore will be useful for existing indexes), the only difference is that you are extracting some additional rows from the result set.

, . , , . , , -10 50.

EDIT: Sam Saffron , 10 50 , , , , .

Answer 2

, , , , .

, , . , , , SQL , .

1 , , , - , , ,

. , , , top 10, top 50 .