Oracle SQL Internals Handbook

Oracle SQL Internals Handbook

Authors: Donald K. Burleson, Joe Celko, Dave Ensor, Jonatha

Pages: 196

Publisher: Unknow

ISBN13: 9780974435510

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.