Tag Archives: Indexing

Oracle Reverse Index

This is one of the least used Oracle indexes I’ve encountered in a data-warehousing environment. However, a very good instrument in performance problems on OLTPs. To understand a reverse key index, we must first look at the regular b-tree index … Continue reading

Posted in DW | Tagged , , , , , , | Leave a comment

Oracle: Partitioning and Indexes 

As I’ve been presenting in the last couple of posts on partitioning, one of the major benefits of this database option is basically the selectivity when filtering on the partition key, what we currently call partition pruning. Now, what we’ve … Continue reading

Posted in DW | Tagged , , , , | Leave a comment