Oracle Index Management Secrets Top Oracle Experts Discuss Index Management Techniques

Team DDU......Page 1
Table of Contents......Page 5
Conventions Used in this Book......Page 8
Foreword......Page 9
When Reorganizing, How Many Extents to Use?......Page 11
Assumptions and Experimental Figures......Page 12
Some Procedures Related to Table Reorganization......Page 13
The Behavior of the "Alter Table/Index Move/Rebuild" Commands......Page 14
Limitations of the "ALTER TABLE MOVE" Command......Page 15
Step 2......Page 16
Prerequisites......Page 18
Overview of the Package......Page 19
Setup......Page 21
About the Author......Page 23
Rebuild in the Same Tablespace......Page 24
8.1 to the Rescue......Page 25
What Goes Where......Page 26
Script......Page 27
Conclusion......Page 28
About the Author......Page 29
Identifying Unused Indexes......Page 30
Identifying All Unused Indexes in a Database......Page 32
Conclusion......Page 35
References......Page 36
About the Author......Page 37
Oracle Blocksize and Index Tree Structures......Page 38
About the Author......Page 42
Introduction......Page 43
When to Partition......Page 44
Different Methods of Partitioning......Page 45
Range Partitioning......Page 46
List Partitioning......Page 47
Composite Range-Hash Partitioning......Page 48
Composite Range-List Partitioning......Page 49
Conclusion......Page 50
About the Author......Page 51
Background......Page 52
Globally Partitioned Indexes......Page 53
Locally Partitioned Indexes......Page 57
Real-life Example......Page 61
Conclusion......Page 62
About the Author......Page 63
Everybody Knows …......Page 64
What Is a Bitmap Index?......Page 65
Do Bitmaps Lock Tables?......Page 66
Consequences of Bitmap Locks......Page 67
Low Cardinality Columns......Page 70
Sizing......Page 76
Conclusion......Page 77
References......Page 78
About the Author......Page 79