Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

  Oracle Index Management Secrets
Top Oracle Experts Discuss Index Management Techniques

Donald Burleson, Mike Hordila, John Weeg, Daniel Liu, Lisa Fernandez, Jonathan Lewis

ISBN:
0-9740716-9-2
46 Pages

Retail Price $14.95 / £10.95 

- Order now from the publisher and get 40% off!

Only $9.95

 


Written by the world's most widely-read Oracle authors, this eBook utilizes their substantial knowledge of Oracle indexing in this concise eBook. With combined experience of over a century, the one of the world's most widely respected authors share their secrets for using Oracle indexes to turbocharge Oracle SQL execution speed.

Not for beginners, this is an advanced guide for the senior Oracle DBA and dives far into the internal mechanisms of Oracle indexing. You will learn from the world's most widely-read Oracle experts how to monitor and optimize Oracle index structures, automate index rebuilding and the understand the internal structures of Oracle indexes.

 
Key Features

* Learn to monitor index usage.

* Understand Oracle index internal structures.

* Explore bitmap indexes.

* Automate index rebuilds.

* Understand multi level index partitioning.

* Learn why database blocksize is critical for Oracle indexes.

* Explore Oracle index tree structures.

 

About the Authors:

This eBook is authored by some of the world's leading Oracle experts.  Donald Burleson is the author of over 30 book, Jonathan Lewis is one of the world most respected Oracle internals experts, Mike Hordila is a noted Oracle consulting expert, Daniel Liu is a senior Oracle DBA and internals expert, John Weeg is a respected Oracle guru, and Lisa Fernandez is a recognized indexing expert.

Table of Contents:

 

Automated Table/Index Reorganization In Oracle8i

When Reorganizing, How Many Extents to Use?
Possible Reorganizing Strategies
Assumptions and Experimental Figures
Some Procedures Related to Table Reorganization
Important Issues Regarding Table/Index Moving/Rebuilding
The Behavior of the “Alter Table/Index Move/Rebuild” Commands
Limitations of the “ALTER TABLE MOVE” Command
Manual Object Reorganization
Step 1
Step 2

Automated Object Reorganization

Prerequisites
Associated Tables
Overview of the Package
Setup
About the Author

Locally Managed Indexes

Rebuild in the Same Tablespace
No Fragment
81 to the Rescue
More Than One
What Goes Where
Break Points
Script
Conclusion
About the Author

Monitoring Index Usage in Oracle9i

Introduction
Identifying Unused Indexes
Identifying All Unused Indexes in a Database
Conclusion



 

Oracle Blocksize and Index Tree Structures

Partitioning in Oracle9i, Release 2 — Part 1

Introduction
Background
Partitioning Defined
When to Partition
Different Methods of Partitioning
Partitioning Tables
Range Partitioning
Hash Partitioning
List Partitioning
Composite Range-Hash Partitioning
Composite Range-List Partitioning
Conclusion

Partitioning in Oracle9i, Release 2 — Part 2

Introduction
Background
Globally Partitioned Indexes
Locally Partitioned Indexes
When to Use Which Partitioning Method
Real-life Example

Understanding Bitmap Indexes

Everybody Knows …
What Is a Bitmap Index?
Do Bitmaps Lock Tables?
Consequences of Bitmap Locks
Problems with Bitmaps
Low Cardinality Columns
Sizing
Conclusion
References

 

 

 

 

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks