Skip to content

Oracle SQL Tuning Pocket Reference Write Efficient SQL

Best in textbook rentals since 2012!

ISBN-10: 0596002688

ISBN-13: 9780596002688

Edition: 2002

Authors: Mark Gurry

List price: $9.95
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. Poorly tuned SQL statements are one of the leading causes of substandard database performance and poor response time. SQL statements that perform poorly result in frustration for users, and can even prevent a company from serving its customers in a timely manner. 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…    
Customers also bought

Book details

List price: $9.95
Copyright year: 2002
Publisher: O'Reilly Media, Incorporated
Publication date: 1/22/2002
Binding: Paperback
Pages: 110
Size: 4.25" wide x 6.97" long x 1.02" tall
Weight: 0.088
Language: English

As a database administrator on a financial IMS project about eight years ago, Mark Gurry was asked to investigate his company's database direction for the next five years. The number of users was up to 950, the cost of maintaining the mainframes was huge, and he'd heard about relational databases and downsizing. After much investigation, he chose Oracle, and has stuck with the system ever since. He has worked as Manager of Computing and Network Services, senior database administrator, senior Oracle technical support, and other jobs. He now has a small consulting company called New Age Consultants. Mark has worked for many large organizations and is currently working for Telecom Australia,…    

Introduction
The SQL Optimizers
Understanding the Rule-Based Optimizer
Understanding the Cost-Based Optimizer
Some Common Optimizer Misconceptions
Which Optimizer to Use?
Rule-Based Optimizer Problems and Solutions
Incorrect Driving Table
Incorrect Index
Incorrect Driving Index
Using the Order By Index and not the Where Index
Cost-Based Optimizer Problems and Solutions
The Skewness Problem
Analyzing with Wrong Data
Mixing the Optimizers in Joins
Choosing an Inferior Index
Joining Too Many Tables
Incorrect Init. Ora Parameter Settings
Problems Common to Rule and Cost with Solutions
Statement Not Written for Indexes
Indexes Are Missing or Inappropriate
Use of Single-Column Index Merge
Misuse of Nested Loop, Sort Merge, or Hash Join
Misuse of in, Exists, Not in, Not Exists, or Table Joins
Unnecessary Sorts
Too Many Indexes on a Table
Use of Or Instead of Union
Tables and Indexes with Many Deletes
Other Problems: Heavy Usage of Views
Other Problems: Joining Too Many Tables
Handy SQL Tuning Tips
Identify Bad SQL
Identify Long-Running SQL Statements
Use Decode for If/Else Selection
Encourage Bind Variables
Using SQL Hints
When Are Hints Ignored?
Using Hints in Views
Available Hints
Using DBMS_STATS to Manage Statistics
Using DBMS_STATS to Analyze Faster
Copying Statistics Using DBMS_STATS
Manipulating Statistics Using DBMS_STATS
Reverting to Previous Statistics
Using Outlines for Consistent Execution Plans
Recording Outlines
Enabling Outlines
Managing Outlines