Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database

Summary

This chapter provided an introduction to various specialized indexes that you can create in an Oracle Database to enhance performance and make index management simpler. You learned how to use invisible indexes to test the efficiency of indexes. This chapter showed you how to take advantage of function-based indexes to influence the optimizer's choice of indexes during the execution of queries where the predicates involve a function on a column. This chapter also explained the benefits of key compression and how and when to compress indexes. Composite indexes are very important in many applications and you learned the advantages of using composite indexes. This chapter showed you both how to create and manage indexes on virtual columns, ...