10 Things You Might Not Know But Really Should About Oracle Indexes (Connect 2019)

An appropraite indexing strategy is crucial in ensuring that both databases and their associated applications perform as efficiently as possible. This presentation will look at 10 Oracle indexing related features and capabilities that might not be very widely know, but can be extremely important for both DBAs and Developers to understand and appreciated when designing and tuning efficient and highly scalable Oracle database-based applications. Topics include the use to TABLE_CACHED_BLOCKS when collecting index related statistics, the use of Partital Indexes, the importance of the table Clustering Attribute and the correct strategy when ordering columns within an index.