Oracle SQL Internals Handbook

Written by the world's top Oracle experts, this eBook is a super-advanced guide to hypercharging Oracle SQL performance. Not for the beginner, this is a guru-level overview of Oracle SQL internals tuning and may be beyond the ability of the average Oracle DBA. Explained are the internal mechanisms for Oracle indexing and how Oracle indexes can be used to fine-tune any Oracle database. Advanced Oracle SQL internals are also explored, including bitmap join indexes, STAR transformations, and SQL diagnostics and SQL tracing. This eBook is indispensable for anyone who must ensure that their Oracle SQL is optimally tuned.