Sumário Itens Encontrados: 210Chapter 1: Introduction to Oracle IndexesPerformance Without an IndexImplementing an Index to Improve PerformanceAccessing Only the IndexOracle Ignoring an IndexDetermining Which Type of Index to UseB-tree IndexesSpecialized Index TypesDetermining Which Columns to IndexIndexes on Primary Key and Unique Key ColumnsIndexes on Foreign Key ColumnsOther Suitable ColumnsIndexing Guidelines Chapter 2: B-tree IndexesUnderstanding How Oracle Uses B-tree IndexesPrepping for B-tree IndexesEstimating the Size of an Index Before CreationCreating Separate Tablespaces for IndexesInheriting Storage Parameters from the TablespaceNaming StandardsImplementing B-tree IndexesCreating a B-tree IndexReporting on IndexesDisplaying Index CodeDropping a B-tree IndexManaging B-tree Indexes with ConstraintsCreating B-tree Index on Primary Key ColumnsCreating a B-tree Index on Unique Key ColumnsIndexing Foreign Key ColumnsMultiple Indexes on the Same Column CombinationsExtended Data TypesIndexing Extended ColumnsVirtual Column SolutionFunction-Based Index Solution Chapter 3: Bitmap IndexesUnderstanding Bitmap IndexesCreating a Bitmap IndexCreating a Partitioned Bitmap IndexCreating a Bitmap Index on an Index-Organized TablePerformance Implications of Querying with Bitmap IndexesPerformance Implications of Loading Data withBitmap IndexesUnderstanding Bitmap Join IndexesCreating a Bitmap Join IndexDuplicating Indexes for PerformanceReporting on Bitmap Indexes Chapter 4: Index-Organized TablesUnderstanding the StructureUnderstanding the AdvantagesCreating an Index-Organized TableAdding an Overfl ow SegmentCompressing an Index-Organized TableBuilding Secondary IndexesRebuilding an Index-Organized TableConverting to or from an Index-Organized TableReporting on Index-Organized Tables Chapter 5: Specialized IndexesInvisible IndexesWhen to Create an Invisible IndexCreating an Invisible IndexFinding Invisible Indexes in Your DatabaseMaking an Invisible Index Available to the OptimizerMaintaining an Invisible IndexDescending IndexesFunction-Based IndexesCreating a Function-Based IndexLimitations of Function-Based IndexesCollecting Statistics for Function-Based IndexesIndexes on Virtual ColumnsKey Compressed IndexesWhen Key Compression is UsefulCreating a Compressed IndexKey Compression and Storage.Advanced Index CompressionComposite IndexesUnderstanding Index Skip Scans and Composite IndexesOrdering the Columns in a Composite IndexChoosing Keys for Composite IndexesCreating Virtual IndexesReverse Key IndexesDisadvantages of a Reverse Key IndexWhen to Use a Reverse Key IndexCreating a Reverse Key IndexApplication Domain Indexes Chapter 6: Partitioned IndexesUnderstanding Partitioned IndexesCreating a Local Partitioned IndexThe Simplest FormPartition-Level RequirementsPrefi xed and Non-Prefi xed Options.Managing Primary Keys and Unique IndexesCreating a Global Partitioned IndexPartial IndexesCreating Local Partial IndexesCreating Global Partial IndexesPerformance Implications of Partial IndexesChoosing the Type of Index for Your ApplicationMaintaining Indexes on Partitioned TablesAdding a PartitionTruncating a PartitionMoving a PartitionSplitting a PartitionExchanging a PartitionDropping a PartitionMerging a PartitionRebuilding Global Partitioned and Non-Partitioned IndexesSetting Index Partitions as Unusable and then RebuildingIndex Implications for Interval PartitioningMaking Older Data Read-OnlyReporting on Partitioned Indexes Chapter 7: Tuning Index UsageOptimizer Access PathsIndex ScansIndex Unique ScanIndex Range ScanIndex Skip ScanIndex Full ScanIndex Fast Full ScanDetermining Whether a Query Uses an IndexAvoiding an IndexAvoiding All Use of an IndexAvoiding Only the Fast Full ScanForcing a Table ScanChoosing Between an Index and a Table ScanWhy the Optimizer May Ignore IndexesNumber of Distinct RowsIndex Clustering FactorHow Index Access Paths Can Change Without New StatisticsUsing the NOT EQUAL ConditionQuerying with Wild CharactersReferencing Null Values in PredicatesWriting Functions in a QuerySkipping the Leading Portion of an IndexForcing the Optimizer to Use an IndexApplying the INDEX Hint.Applying Related HintsTroubleshooting a Failed INDEX HintAdjusting the optimizer_index_cost_adj ParameterCollecting Accurate Statistics for an IndexParallelizing Index Access Chapter 8: Maintaining IndexesGathering Statistics for IndexesThe DBMS_STATS PackageThe METHOD_OPT ParameterWorking with Unusable IndexesMaking an Index UnusableSpecifying the SKIP_UNUSABLE_INDEXES ParameterAsynchronous Global Index MaintenanceThe Role of the INDEX_STATS View in Index RebuildsBenefi ts of the INDEX_STATS ViewProblems with the INDEX_STATS ViewIndex Rebuilding: The DebateArguments for RebuildingArguments Against RebuildingCoalescing Indexes to Reduce FragmentationShrinking Indexes to Reduce FragmentationMoving Tables and IndexesImproving Index Creation Effi ciencyParallelizing Index CreationAvoiding Redo Generation During Index CreationUsing Larger Block SizesCompressing IndexesUsing Multiple Options TogetherGenerating the DDL for Creating an IndexUsing the DBMS_METADATA PackageUsing the SESSION_TRANSFORM ProcedureUsing the SET_FILTER ProcedureUsing Data PumpDropping an IndexDropping an Index OnlineThe Hazards of Dropping an Index Chapter 9: SQL Tuning AdvisorAutomatic SQL Tuning JobVerifying Automatic Jobs RunningViewing Automatic SQL Tuning Job AdviceGenerating a SQL Script to Implement Automatic Tuning AdviceDisabling and Enabling Automatic SQL TuningManaging SQL Tuning SetsViewing Resource-Intensive SQL in the AWR.Viewing Resource-Intensive SQL in MemoryPopulating SQL Tuning Set from High-Resource SQL in AWRPopulating a SQL Tuning Set from High-Resource SQL in MemoryPopulating SQL Tuning Set with All SQL in MemoryDisplaying the of a SQL Tuning SetSelectively Deleting Statements from a SQL Tuning SetAdding Statements to an Existing SQL Tuning SetDropping a SQL Tuning SetRunning the SQL Tuning AdvisorCreating a Tuning TaskExecute DBMS_SQLTUNE and View the AdviceViewing and Dropping Tuning TasksRunning SQL Tuning Advisor from SQL DeveloperRunning SQL Tuning Advisor from Enterprise Manager Chapter 10: In-Memory Column StoreTraditional Row Store FormatColumnar Format.Use Cases for IM Column StoreEnabling a Database for the IM Column Store.Enabling a Table for IM Column StoreExcluding ColumnsEnabling New Tables to Automatically Use In-MemoryDetermining if a Query Is Used in the IM Column StoreViewing the Execution PlanDisplaying Session-Level StatisticsQuerying the Data DictionaryObserving Performance DifferencesSetting a PrioritySizing the IM Column Store Memory AreaAdjusting CompressionUtilizing IM Column Store with RAC