This script is supported only in SQL SERVER 2000, This shows only indexes created by users in tables.
Parameter @tabela--> You can put the table name and get the information about users indexes in this table.
Or
You can put nothing (NULL) and see all tables on the schema and how many indexes each table have.
Rebuilding Stats: Twice or Not At All
Are you rebuilding statistics twice on your tables? Longtime expert, Andy Warren, shows why you might be asking more work of your SQL Server than is required.
2008-07-29
9,130 reads