Zusammenfassung der Ressource
SQL Server Non-Clustered Indexes
- 7 Patterns
- Search Columns
- Index Intersections
- Mutiple columns
- Covering Indexes
- Included Columns
- Filtered Indexes
- Foreign Keys
- Common NonCL Considerations
- Frequency of change
- queries that will improve
- Business needs
- Cost to maintain