Rampant eBooks

Advanced SQL Database Programmer Handbook: Written by the world's top SQL programmers, this eBook utilizes their substantial knowledge in SQL database programming. With combined experience of over a century, these experts share their secrets for programming with SQL. This is an advanced eBook that explores topics such as using advanced SQL constructs and writing programs that utilize complex SQL queries. Not for the beginner, this eBook explores complex time-based SQL queries, managing set operations in SQL, and relational algebra with SQL. This is an indispensable handbook for any developer who is challenged with writing complex SQL inside applications....

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....

Oracle Space Management Handbook: Written by some of the world's top authors, this exciting eBook provides you with everything that you need to know to manage Oracle storage. Explained are how to monitor and reduce disk I/O, how to set up tablespaces for maximum efficiency, and how to define Oracle tables and indexes to make the most efficient use of disk storage. Not for the beginner, this is a guru-level advanced Oracle handbook with highly detailed explanations of Oracle storage internals. This eBook is laden with useful scripts that will allow you to quickly see inside your data files and tablespaces and tune them for optimal performance. ...

Oracle Index Management Secrets: Written by the world's top Oracle authors, this eBook utilizes their substantial knowledge of Oracle indexing. With combined experience of over a century, the world's best authors share their secrets for using Oracle indexes to turbocharge Oracle SQL execution speed. Not for beginners, this is an advanced guide for the senior Oracle DBA and dives far into the internal mechanisms of Oracle indexing. Explained are how to monitor and optimize Oracle index structures, how to automate index rebuilding, and the internal structures of Oracle indexes....

Setting Up for Use of Outlines,Installing OUTLN Schema 'After the Fact'. Script to Install OUTLN Schema, General Facts about OUTLN Schema, Requirements for OUTLINE Use.Some General Usage Notes:Views Used With OUTLINES,Packages Used with OUTLINEs,Plan Stability, Creation of a OUTLINE object.Altering a OUTLINE. Dropping an OUTLINE. Use of the OUTLN_PKG To Manage SQL Stored Outlines. DROP_UNUSED. DROP_BY_CAT. UPDATE_BY_CAT. New Procedures for Oracle9i:Manually Editing Plans, Using DML and Packages to Edit Outlines.A Detailed Example: Using DBMS_OUTLN_EDIT.GENERATE_SIGNATURE,Replacing a Non-Hinted Outline,Technique. Example. Moving OUTLINES from One DB to Another....