oracle位图索引.pptVIP

 What a DBA Needs to Know AboutOracle’s Bitmap Indexing to Retrieve Data Quickly? Part I Vilin Roufchaie Cingular Wireless vilin.roufchaie@ veeleen@ Download slides: Presentation Assumptions Prerequisites Familiarity with basic Database and Data Warehouse concepts is required Bitmap and Bit Vector will be used interchangeably Who Is This Presentation For? Data warehouse designers developers DBAs Performance DBAs Capacity Planners Presentation SummaryPart I Overview, Characteristics, Structure Size of a Bitmap Index Performance Considerations of Bitmap Indexing Logical Layout of Bitmap Indexes Bitmap Index Creation Storage Issues Query Processing Bitmap Index Access Paths Presentation SummaryPart II Star Schema, Join, Transformation Star Optimization, and Transformation CBO Estimation Query Transformer Enabling Star Transformation Star Transformation Steps Presentation SummaryPart II Joinback Elimination Case Study Explain Plan Review To “Star Query”? OrTo “Star Transform” ? Conclusions Acknowledgements Indexing Rules-of-Thumb In building an index know: data selectivity, data distribution, workload, execution plan, proof of utilization. There is cost overhead in building, utilizing, tuning, maintaining indexes of any sort! What do we expect after paying those cost? Indexing Rules-of-Thumb Performance! Orders of magnitude in execution speed ? Ideal!! How about what makes the Business/users happy! Make sure business expectations are understood adequate research tests are done to assess the likelihood of succeeding before committing to something Indexing Rules-of-Thumb The index must be beneficial to all SQLs impacted by it across the board -- Wholly beneficial Try Aggregate/Collective tuning So we want to build few, efficient indexes Demand: Low-overhead indexes, requiring less frequent fast re/builds, be space-efficient Overview Of Bitmap Indexing Bitmap indexing is a query execution optimization technique in Data Warehousin