Expert Oracle SQL : optimization, deployment, and statistics
Hasler, Tony
Expert Oracle SQL : optimization, deployment, and statistics / Tony Hasler ; foreword by Tanel Pöder - xxxi, 585 pages - Expert's voice in Oracle .
Includes index.
Part 1. Basic concepts SQL features The cost-base optimizer Basic execution plan concepts The runtime engine Introduction to tuning Objects statistics and deployment Part 2. Advanced concepts Advanced SQL concepts Advanced execution plan concepts Object statistics Part 3. The cost-based optimizer Access methods Joins Final state optimization Optimizer transformations Part 4. Optimization Why do things go wrong? Physical database design Rewriting queries Optimizing sorts Using hints Advanced tuning techniques Part 5. Managing statistics with TSTATS Managing statistics with TSTATS
9781430259770
Oracle (Computer file)
SQL (Computer program language)
Database management
005.7565
Expert Oracle SQL : optimization, deployment, and statistics / Tony Hasler ; foreword by Tanel Pöder - xxxi, 585 pages - Expert's voice in Oracle .
Includes index.
Part 1. Basic concepts SQL features The cost-base optimizer Basic execution plan concepts The runtime engine Introduction to tuning Objects statistics and deployment Part 2. Advanced concepts Advanced SQL concepts Advanced execution plan concepts Object statistics Part 3. The cost-based optimizer Access methods Joins Final state optimization Optimizer transformations Part 4. Optimization Why do things go wrong? Physical database design Rewriting queries Optimizing sorts Using hints Advanced tuning techniques Part 5. Managing statistics with TSTATS Managing statistics with TSTATS
9781430259770
Oracle (Computer file)
SQL (Computer program language)
Database management
005.7565