Query Tuning + Index Tuning

4 maio 2018, 09:30 • Bruno Emanuel Da Graça Martins

• Query Tuning
• Use of temporaries
• Join conditions
• Use of Having
• Use of views
• Triggers
• Index Tuning
• Types of Queries
• Impact of the Size of the Search Key
• Index Data Structures
• Clustered/Non-clustered/No indexes
• Covering/Composite Indexes

Lab 8: Query Tuning

4 maio 2018, 08:00 • Diogo Ribeiro Ferreira

Tutorial about query tuning in SQL Server. Exercise about privileged and unprivileged tables.

LAb 7: Schema Tuning

27 abril 2018, 11:00 • Diogo Ribeiro Ferreira

Tutorial about materialized/indexed views in SQL Server. Exercises about schema tuning for query optimization.

Query Tuning

27 abril 2018, 09:30 • Bruno Emanuel Da Graça Martins

• Schema Tuning and Materialised Views for Aggregate Maintenance
• Query Tuning and Query Rewriting Techniques
• Maximizing Index Usage
• DISTINCTs Elimination
• Rewriting (Correlated) Subqueries

Query Tuning

27 abril 2018, 09:30 • Bruno Emanuel Da Graça Martins

• Schema Tuning and Materialised Views for Aggregate Maintenance
• Query Tuning and Query Rewriting Techniques
• Maximizing Index Usage
• DISTINCTs Elimination
• Rewriting (Correlated) Subqueries