Expert Oracle SQL : optimization, deployment, and statistics / Tony Hasler ; foreword by Tanel Pöder
By: Hasler, Tony [author].
Material type:
BookSeries: Expert's voice in Oracle.Publisher: [Berkeley, California] : [Apress], [2014]Description: xxxi, 585 pages.Content type: text Media type: unmediated Carrier type: volumeISBN: 9781430259770.Subject(s): Oracle (Computer file) | SQL (Computer program language) | Database management | Computers & technology| Item type | Current location | Collection | Call number | Status | Date due | Barcode | Item holds |
|---|---|---|---|---|---|---|---|
| Book | Main Library Reference Section | Circulation | C 005.7565 H352e 2014 (Browse shelf) | Available | 125279d |
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
Click on an image to view it in the image viewer
There are no comments for this item.