Scribd
Upload
29 views9 pages

0 Query Tuning Introduction m00 Introduction Slides

The document provides an introduction to query tuning, emphasizing that performance tuning is an ongoing process. Key topics include understanding execution plans, query design, indexing techniques, and identifying resource bottlenecks. It also outlines the steps involved in query processing and optimization, including parsing, binding, and execution.

Uploaded by

Orcun Iyigun
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
29 views9 pages

0 Query Tuning Introduction m00 Introduction Slides

The document provides an introduction to query tuning, emphasizing that performance tuning is an ongoing process. Key topics include understanding execution plans, query design, indexing techniques, and identifying resource bottlenecks. It also outlines the steps involved in query processing and optimization, including parsing, binding, and execution.

Uploaded by

Orcun Iyigun
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Introduction to Query Tuning

Pinal Dave
[Link]

Vinod Kumar M
[Link]
Performance Tuning
is a journey not a
destination !!!
Getting Started

 Understand Execution Plan


 Query Designing and Re-writing
 Essential Indexing Techniques
 Identify Resource bottlenecks
 Avoiding Pitfalls
Simple Flow Chart
Start

Slow Performance

Performance Tuning

End
Real Pie Chart

Hardware Execution
Plan

Server Query
Configuration Designing

Common Indexing
Mistakes Techniques

Resource
Bottlenecks
Real Pie Chart

Hardware Execution
Plan

Server Query
Configuration Designing

Common Indexing
Mistakes Techniques

Resource
Bottlenecks
Query Processing and Optimization

Parsing

Binding

Optimization

Execution
Query Processing and Optimization

 Cost Based Optimizer


 Disk IO Cost
 CPU Cost

 Memory Cost – Very insignificant

 Indexes
 Query Algorithms
 Query Optimization
 Query Evaluation

Introduction to Query Processing and Optimization


Michael L. Rupley, Jr. | Indiana University at South Bend
Demo

 Sample Query
 Execution Plan
 Query Cost

You might also like