Sumário Itens Encontrados: 202CHAPTER 1 What Do You Mean by Cost?Optimizer OptionsSo What Is the Cost?Transformation and CostingWYSIWYG?Test CasesCHAPTER 2 TablescansGetting StartedOnwards and UpwardsEffects of Block SizesCPU CostingThe Power of CPU CostingThe BCHR Is Dead! Long Live the BCHR!Parallel ExecutionIndex Fast Full ScanPartitioningCHAPTER 3 Single Table SelectivityNull ValuesUsing Lists10g UpdateRange PredicatesTwo PredicatesProblems with Multiple PredicatesCHAPTER 4 Simple B-tree AccessBasics of Index CostingEffective Index SelectivityEffective Table Selectivityclustering_factorPutting It TogetherExtending the AlgorithmThe Three SelectivitiesLoose EndsCHAPTER 5 The Clustering FactorBaseline ExampleReducing Table Contention (Multiple Freelists)Reducing Leaf Block Contention (Reverse Key Indexes)Reducing Table Contention (ASSM)Reducing Contention in RAC (Freelist Groups)Column OrderExtra ColumnsCorrecting the StatisticsThe sys_op_countchg() TechniqueInformal StrategiesCHAPTER 6 Selectivity IssuesDifferent Data TypesDate ValuesCharacter ValuesDaft Data TypesLeading ZerosDeadly DefaultsDiscrete DangersSurprising sysdateFunction FiguresCorrelated ColumnsDynamic SamplingOptimizer ProfilesTransitive ClosureConstraint-Generated PredicatesCHAPTER 7 HistogramsGeneric HistogramsHistograms and Bind VariablesWhen Oracle Ignores HistogramsFrequency HistogramsFaking Frequency HistogramsWarning to FakersâHeight Balancedâ HistogramsThe ArithmeticData Problems RevisitedDaft DatatypesDangerous DefaultsCHAPTER 8 Bitmap IndexesThe Index ComponentThe Table ComponentBitmap CombinationsLow CardinalityNull ColumnsInteresting CasesMulticolumn IndexesBitmap Join IndexesBitmap TransformationsCHAPTER 9 Query TransformationEvolutionFilteringFilter OptimizationScalar SubqueriesSubquery FactoringComplex View MergingPushing PredicatesGeneral SubqueriesSubquery ParametersCategorizationSemi-JoinsAnti-JoinsAnti-join AnomalyNulls and Not InThe ordered HintStar Transformation JoinsStar JoinsThe FutureCHAPTER 10 Join CardinalityBasic Join CardinalityBiased JoinsJoin Cardinality for Real SQLExtensions and AnomaliesJoins by RangeNot EqualOverlapsHistogramsThree TablesNullsImplementation IssuesDifficult Bits!FeaturesAn Alternative ViewpointCHAPTER 11 Nested LoopsBasic MechanismWorked ExampleSanity ChecksCHAPTER 12 Hash JoinsThe Optimal Hash JoinThe Onepass Hash JoinThe Multipass Hash JoinTrace FilesEvent 10104Event 10053HeadachesTraditional CostingModern CostingComparisonsMultitable JoinsCHAPTER 13 Sorting and Merge JoinsMemory UsageCPU Usagesort_area_retained_sizepga_aggregate_targetReal I/OCost of Sorts10053 traceMerge JoinsThe Merge MechanismA Merge Join Without the First SortThe Cartesian Merge JoinAggregates and OthersIndexesSet OperationsFinal WarningCHAPTER 14 The 10053 Trace FileThe QueryThe Execution PlanThe EnvironmentThe Trace FileParameter SettingsQuery BlocksStored StatisticsSingle TablesGeneral PlansJoin order[1]Join order[2]Join order[3]Join order[4]Join order[5]Join order[6]Join order[7]Join order[8]Join order[9]Join order[10]Join order[11]Join order[12]Join order[13]Join order[14]Join order[15]Join order[16]Join order[17]Join order[18]Join EvaluationAPPENDIX A Upgrade Headachesdbms_statsRounding ErrorsBind Variable PeekingNulls Across JoinsB-tree to Bitmap ConversionsIndex Skip-ScansAND-EqualIndex Hash JoinIn-List Fixedsysdate Arithmetic FixedIndexing NullsSortingGroupingGoing Outside the LimitsType Hackingoptimizer_modeDescending IndexesUnnest SubqueryScalar and Filter SubqueriesParallel Query Changes x 2Temporary TablesDictionary StatsAPPENDIX B Optimizer Parametersoptimizer_features_enableThe 10053 Trace Filev$sql_optimizer_env