Query Performance Tuning
Improve Indexes
Create Highly-Selective Indexes
Create Multiple-Column Indexes
Avoid Indexing Small Tables
Choose What to Index
Use the Query Optimizer
Understand Response Time vs. Total Time
Index the ORDER-BY / GROUP-BY / DISTINCT Columns for Better Response Time
Rewrite Subqueries to Use JOIN
Limit Using Outer JOINs
Use Parameterized Queries
Query Only When You Must
Create Highly-Selective Indexes
Create Multiple-Column Indexes
Avoid Indexing Small Tables
Choose What to Index
Use the Query Optimizer
Understand Response Time vs. Total Time
Index the ORDER-BY / GROUP-BY / DISTINCT Columns for Better Response Time
Rewrite Subqueries to Use JOIN
Limit Using Outer JOINs
Use Parameterized Queries
Query Only When You Must
No comments:
Post a Comment