Indexing

• Create In Order Of Frequency Of Use And After Data Loads Are Done
• Avoid Highly Duplicate / Unneeded Indexes
• Use Detached Indexes - isolate disk I/O
• Test index Fragment By Expression For Large Tables Across 2 - 4 Frags

Previous slide

Next slide

Back to first slide

View graphic version