Expert Oracle Indexing and Access Paths

Indexing is at the heart of any database administrator's job. Corporate databases must provide fast answers to business questions, and administrators are the first ones called when those answers come slowly. And in turn administrators inevitably turn to indexes -- their proper application and usage. Expert Oracle Indexing and Access Paths is a second edition of our four-star book on indexing for Oracle Database 11g. In this new edition the authors have revised their content to make it current with the most recent database release. Expert Oracle Indexing and Access Paths provides succinct guidance on the administrator's #1 performance tool -- the index.

Explains how indexes help performance, and sometimes hinder it too Demystifies the various index choices so that you can chose rightly Describes the database administration chores associated with indexes

Autorentext
Darl Kuhn is a senior database administrator working for Oracle. He handles all facets of database administration from design and development to production support. He also teaches advanced database courses at Regis University in Colorado. Darl does volunteer DBA work for the Rocky Mountain Oracle Users Group. He has a graduate degree from Colorado State University and lives near Spanish Peaks, Colorado, with his wife, Heidi, and daughters, Brandi and Lisa.
Sam R. Alapati is an experienced Oracle database administrator who holds the Oracle Certified Professional designation and the Hewlett-Packard UNIX System Administrator certification. He currently manages Oracle databases at the Boy Scouts of America's national headquarters in Los Colinas, Texas. Alapati has been dealing with databases for a long time, including the Ingres RDBMS in the mid-1980s. He is also well-versed in the Microsoft SQL Server, Sybase, and IBM DB2 database management systems.

Bill Padfield is an Oracle Certified Professional, working for a large telecommunications company in Denver, Colorado as a lead database administrator. Bill helps administer and manage a large data warehouse environment consisting of more than 75 databases. Bill has been an Oracle Database administrator for more than 14 years, and has been in the IT industry since 1985. Bill also teaches graduate database courses at Regis University and currently resides in Aurora, Colorado with his wife, Oyuna, and son, Evan.

Inhalt

1. Introduction to Oracle Indexes.- 2. B-Tree Indexes.- 3. Bitmap Indexes.- 4. Index-organized Tables.- 5. Specialized Indexes.- 6. Partitioned Indexes.- 7. Tuning Index Usage.- 8. Maintaining Indexes.- 9. SQL Tuning Advisor.- 10. In Memory Column Store.