Oracle SQL Tuning Pocket Reference : Pocket References - Mark Gurry

Instant online reading.
Don't wait for delivery!
Go digital and save!

Oracle SQL Tuning Pocket Reference

By: Mark Gurry

Write A Review

Paperback | 5 December 2001

At a Glance

Paperback
100 Pages

Dimensions(cm)
26 x 108 x 177

Paperback

RRP $18.90

$12.75

33%OFF

or 4 interest-free payments of $3.19 with

Ships in 15 to 25 business days

In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients. Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. He also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. In addition to the specific problem/solution scenarios for the optimizers, the book provides a number of SQL tuning tips. It discusses the various optimizer hints, telling you when they can be used to good effect. Finally, it discusses the use of the DBMS_STATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify..

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

More in Database Programming

SQL Cookbook

Query Solutions and Techniques for All SQL Users 2nd Edition

Paperback

RRP $125.75

$60.99

51%
OFF

PostgreSQL : Up and Running

A Practical Guide to the Advanced Open Source Database : 3rd Edition

Paperback

RRP $85.75

$43.75

49%
OFF

SQL for Data Analysis

Advanced Techniques for Transforming Data into Insights

Paperback

RRP $125.75

$60.99

51%
OFF

SQL Tuning

O'Reilly Ser.

Paperback

RRP $75.99

$39.75

48%
OFF

T-SQL Fundamentals

Developer Reference

Paperback

RRP $87.13

$72.75

17%
OFF

97 Things Every Programmer Should Know

OREILLY

Paperback

RRP $76.00

$39.75

48%
OFF

Efficient MySQL Performance

Best Practices and Techniques

Paperback

RRP $125.75

$60.99

51%
OFF

Domain-Specific Small Language Models - Guglielmo Iozzia

$41.00

61%
OFF

Oracle PL/SQL Programming

Paperback

RRP $152.00

$89.99

41%
OFF

SQL Pocket Guide

A Guide to SQL Usage

Paperback

RRP $68.75

$35.99

48%
OFF

Sams Teach Yourself SQL in 10 Minutes a Day : 5th edition - Ben Forta

$47.75

50%
OFF

Joe Celko's SQL Puzzles and Answers, Second Edition

The Morgan Kaufmann Series in Data Management Systems

Paperback

RRP $105.95

$74.75

29%
OFF

Web Database Applications with PHP and MySQL 2e

OREILLY

Paperback

RRP $95.00

$47.75

50%
OFF

Mastering Oracle SQL 2e

O'Reilly Ser.

Paperback

RRP $95.00

$38.00

60%
OFF

Oracle PL/SQL Best Practices

O'Reilly Ser.

Paperback

RRP $57.00

$22.00

61%
OFF

MySQL in a Nutshell

A Desktop Quick Reference

Paperback

RRP $66.75

$26.00

61%
OFF

LINQ Pocket Reference

Pocket Reference (O'Reilly)

Paperback

RRP $38.00

$15.00

61%
OFF

PHP & MySQL

The Missing Manual

Paperback

RRP $76.00

$30.00

61%
OFF

Transact-SQL Cookbook

Cookbooks Ser.

Paperback

RRP $76.00

$30.00

61%
OFF

Using SQLite

OREILLY

Paperback

RRP $95.00

$47.75

50%
OFF

Perl Programming in easy steps

In Easy Steps

Paperback

RRP $55.99

$47.99

14%
OFF

Introduction	p. 1
The SQL Optimizers	p. 4
Understanding the Rule-Based Optimizer	p. 5
Understanding the Cost-Based Optimizer	p. 11
Some Common Optimizer Misconceptions	p. 19
Which Optimizer to Use?	p. 19
Rule-Based Optimizer Problems and Solutions	p. 20
Incorrect Driving Table	p. 21
Incorrect Index	p. 22
Incorrect Driving Index	p. 23
Using the Order By Index and not the Where Index	p. 25
Cost-Based Optimizer Problems and Solutions	p. 26
The Skewness Problem	p. 26
Analyzing with Wrong Data	p. 29
Mixing the Optimizers in Joins	p. 31
Choosing an Inferior Index	p. 33
Joining Too Many Tables	p. 36
Incorrect Init. Ora Parameter Settings	p. 38
Problems Common to Rule and Cost with Solutions	p. 43
Statement Not Written for Indexes	p. 43
Indexes Are Missing or Inappropriate	p. 47
Use of Single-Column Index Merge	p. 50
Misuse of Nested Loop, Sort Merge, or Hash Join	p. 51
Misuse of in, Exists, Not in, Not Exists, or Table Joins	p. 54
Unnecessary Sorts	p. 59
Too Many Indexes on a Table	p. 61
Use of Or Instead of Union	p. 63
Tables and Indexes with Many Deletes	p. 64
Other Problems: Heavy Usage of Views	p. 66
Other Problems: Joining Too Many Tables	p. 67
Handy SQL Tuning Tips	p. 67
Identify Bad SQL	p. 67
Identify Long-Running SQL Statements	p. 68
Use Decode for If/Else Selection	p. 69
Encourage Bind Variables	p. 70
Using SQL Hints	p. 72
When Are Hints Ignored?	p. 73
Using Hints in Views	p. 74
Available Hints	p. 74
Using DBMS_STATS to Manage Statistics	p. 94
Using DBMS_STATS to Analyze Faster	p. 94
Copying Statistics Using DBMS_STATS	p. 95
Manipulating Statistics Using DBMS_STATS	p. 96
Reverting to Previous Statistics	p. 97
Using Outlines for Consistent Execution Plans	p. 98
Recording Outlines	p. 98
Enabling Outlines	p. 100
Managing Outlines	p. 101
Table of Contents provided by Syndetics. All Rights Reserved.

Oracle SQL Tuning Pocket Reference

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Database Programming

SQL Cookbook

Query Solutions and Techniques for All SQL Users 2nd Edition

PostgreSQL : Up and Running

A Practical Guide to the Advanced Open Source Database : 3rd Edition

SQL for Data Analysis

Advanced Techniques for Transforming Data into Insights

SQL Tuning

O'Reilly Ser.

T-SQL Fundamentals

Developer Reference

97 Things Every Programmer Should Know

OREILLY

Efficient MySQL Performance

Best Practices and Techniques

Domain-Specific Small Language Models

Data Pipelines with Apache Airflow, Second Edition

Orchestration for data and AI

Head First PHP & MySQL

A Brain-friendly Guide

Oracle PL/SQL Programming

SQL Pocket Guide

A Guide to SQL Usage

Sams Teach Yourself SQL in 10 Minutes a Day

5th edition

Learning Oracle PL/SQL

Learning Ser.

Joe Celko's SQL Puzzles and Answers, Second Edition

The Morgan Kaufmann Series in Data Management Systems

Web Database Applications with PHP and MySQL 2e

OREILLY

Mastering Oracle SQL 2e

O'Reilly Ser.

Oracle PL/SQL Best Practices

O'Reilly Ser.

MySQL in a Nutshell

A Desktop Quick Reference

LINQ Pocket Reference

Pocket Reference (O'Reilly)

PHP & MySQL

The Missing Manual

Transact-SQL Cookbook

Cookbooks Ser.

Using SQLite

OREILLY

Perl Programming in easy steps

In Easy Steps

This product is categorised by