Thus far, you’ve learned how to create normal Oracle indexes, which include both B-tree indexes as well as bitmap indexes. You also learned how to create and manage index organized tables. This chapter explains several specialized indexes that you can create for serving various needs. Most of these specialized indexes are actually B-tree indexes, so it’s not the organization of the index that makes them special. For example, an invisible index ...
© Darl Kuhn, Sam R. Alapati and Bill Padfield 2016
Darl Kuhn, Sam R Alapati and Bill Padfield, Expert Oracle Indexing and Access Paths, 10.1007/978-1-4842-1984-3_5
5. Specialized Indexes
Darl Kuhn1 , Sam R. Alapati2 and Bill Padfield3
(1)Morrison, Colorado, USA
(2)Flower Mound, Texas, USA
(3)Aurora, Colorado, USA
Get Expert Oracle Indexing and Access Paths: Maximum Performance for Your Database now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
