Quick steps: 12 indexing tips in 12 minutes
these tips view all of Chapter 10, Boosting Performance with Indexes.
Boosting performance with indexes
1. Creating a clustered index using code
2. Creating indexes using the Enterprise Manager
3. Creating a nonclustered index in code
4. Viewing index information using sp_helpindex
5. Rebuilding all indexes using DBCC DBREINDEX
6. Querying and updating index statistics
7. Creating a trace
8. Creating an index with Index Tuning Wizard
9. Creating an indexed view
10. Using the Full-Text Wizard
11. Executing full-text searches using FREETEXT
12. Searching using CONTAINS
To download the complete chapter, click for the .pdf.
No comments:
Post a Comment