In Oracle8 we saw the addition of bitmap indexes, function-based indexes, as well as reverse key indexes and star index structures. We also saw the Oracle SQL optimizer becoming more intelligent about the way indexes are used by SQL statements. In Oracle9i, we have the index skip scan, the and_equal hint to combine individual indexes into a contaminated index, as well as specialized bitmap access methods to improve the speed of data warehouse queries. | presents: ORACLE Index Management Secrets the world’s top Oracle experts discuss index management techniques foreword by Don Burleson sponsored by BMC Software sponsored by BMC Software Contents Foreword i Don Burleson Automated Table/Index Reorganization In Oracle8i 1-1 Mike Hordila Locally Managed Indexes . 2-1 John Weeg Monitoring Index Usage in Oracle9i 3-1 Daniel T. Liu Oracle Blocksize and Index Tree Structures . 4-1 Don Burleson Partitioning in Oracle9i, Release 2 — Part 1 5-1 Liza Fernandez Partitioning in Oracle9i, Release 2 — Part 2 . 6-1 Liza Fernandez Understanding Bitmap Indexes . 7-1 Jonathan Lewis Links to external sites are subject to change; and BMC Software do not control or endorse the content of these external web sites, and are not responsible for their content. © 2003-2004 and BMC Software. All Rights Reserved. 2 sponsored by BMC Software Foreword by Donald K. Burleson Over the past decade, Oracle Corporation has introduced an unprecedented array of new indexing structures. Stemming from original B*tree index structure, Oracle has progressively introduced more complex index structures to allow Oracle SQL to efficiently access data. In Oracle8 we saw the addition of bitmap indexes, function-based indexes, as well as reverse key indexes
