Performing Index Maintenance and Using Performance Tools

Now that you have indexes defined for the tables in your database, the next step is to see how to maintain them. Because indexes are constantly changing, their structure must be inspected every so often to make sure that they are still working efficiently. In addition, you have also learned how to create two very different types of indexes. The first type includes the indexes that are contained within the SQL Server, and the second includes the full-text indexes that are outside of the server.

In this section, you will learn how to use several of the tools available in SQL Server 2000 to investigate how the indexes are performing. In addition, you will see how to set up automatic, scheduled ...

Get Sams Teach Yourself Transact-SQL in 21 Days, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.