SQL Performance Optimization

Here we list the techniques for optimizing the query performance:

Query Execution Plans

Partitioning

Partitioned Tables

Partitioned Indexes

 Partitioned Heap

Indexes:

Covering Indexes

Filtered Indexes

Indexed Views

Report/DW Query Optimization

De-normalization

Routine Aggregation Using Summary Tables

Performance Monitoring

Monitoring Tools

Key Query Performance Metrics

Management Data Warehouse and Data Collection Components

Performance Tuning

Query Tuning Based on Disk I/O

Joins

Using Execution Plans for Tuning

Isolation Levels

Best Practices

Leave a Reply

Your email address will not be published. Required fields are marked *