Implementing Reverse-Key Indexes- Tables and Constraints
Reverse-key indexes are similar to B-tree indexes, except that the bytes of the index key are reversed when an index...
George Vest
Implementing Bitmap Indexes- Tables and Constraints
Bitmap indexes are recommended for columns with a relatively low degree of distinct values (low cardinality). You should not use...
Creating Unique Indexes- Tables and Constraints
When you create a B-tree index, you can also specify that the index be unique. Doing so ensures that non-NULL...
Creating Multiple Indexes on the Same Set of Columns- Tables and Constraints
Multiple indexes can be on the same set of columns, but there must be something physically different about the index....
Viewing Index Metadata- Tables and Constraints
Oracle provides two types of views containing details about the structure of the indexes: • INDEX_STATS • DBA/ALL/USER_INDEXES The INDEX_STATS...
Creating Indexes- Tables and Constraints
As described previously, when you think about creating tables, you must think about the corresponding index architecture. Creating the appropriate...
Creating Separate Tablespaces for Indexes- Tables and Constraints
For critical applications, you must give some thought to how much space tables and indexes will consume and how fast...
Estimating the Size of an Index Before Creation- Tables and Constraints
If you do not work with large databases, then you do not need to worry about estimating the amount of...
Planning for Robustness- Tables and Constraints
After you have decided that you need to create an index, it is prudent to make a few foundational decisions...
Reactively Creating Indexes- Tables and Constraints
Rarely do DBAs and developers accurately create the right mix of indexes when first deploying an application. And that is...