Cost-Based Oracle Fundamentals

• Κύριος συγγραφέας: Lewis, Jonathan (Συγγραφέας)
• Συγγραφή απο Οργανισμό/Αρχή: SpringerLink (Online service)
• Μορφή: Ηλεκτρονική πηγή Ηλ. βιβλίο
• Γλώσσα: English
• Έκδοση: Berkeley, CA : Apress, 2006.
• Θέματα: Computer science.; Software engineering.; Computer Science.; Software Engineering/Programming and Operating Systems.

The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've c...

Πίνακας περιεχομένων:

• What Do You Mean by Cost?
• Tablescans
• Single Table Selectivity
• Simple B-tree Access
• The Clustering Factor
• Selectivity Issues
• Histograms
• Bitmap Indexes
• Query Transformation
• Join Cardinality
• Nested Loops
• Hash Joins
• Sorting and Merge Joins
• The 10053 Trace File.