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.OrYou can put nothing (NULL) and see all tables on the schema and how many indexes each table have.
Interesting info about why the optimizer might choose to use a nonclustered index over a clustered index. Links to two other articles that cover each type of index in more detail.
This sp is used to update index in a database. This sp has got three optional varchar parameters. First parameter will take the tablename. Second parameter will take the indexname. Third parameter will take the fillfactor. The following option we can execute the sp in a user database.1. exec StabilizeIndexIt will update all index in […]
Chris does a follow up to his very popular article on clustered indexes. They seem simple, but in practice they are fairly complicated. Having a solid understanding of clustered indexes will definitely help you get the results you need.