This article explores the internals of Oracle9i indexing; reviews the standard b-tree index, index-only tables, and how these indexes may increase the speed of Oracle SQL queries.

DB Optimizer 2.0 takes SQL tuning beyond standard hint injections and SQL rewrites by offering advanced features such as Index Analysis and VST diagrams. With the new DB Optimizer 2.0, "we have ...

Nearly one year after introducing the X9M, Oracle has teamed up with Advanced Micro Devices Inc. to leverage the chipmaker’s EPYC processor and extend the capabilities of its enterprise database.