Sumários

Index Tuning

9 maio 2017, 11:00 Helena Galhardas

  • Types of queries
  • Considerations on the choice of search key
  • Considerations on the choice of index data structure
  • Index data structures and considerations on performance
  • Covering indexes and indexes with composite search keys
  • Indexes on small tables.


Index Tuning

9 maio 2017, 11:00 Helena Galhardas

  • Types of queries
  • Considerations on the choice of search key
  • Considerations on the choice of index data structure
  • Index data structures and considerations on performance
  • Covering indexes and indexes with composite search keys
  • Indexes on small tables.


Lab 8

9 maio 2017, 09:30 Carlos Mendes

1. Query Tuning 

1.1. Rules of thumb for query tuning 
2. Index Tuning 
2.1 Using the the Database Engine Tuning Advisor 
3. Experiments and Exercises 
3.1. A Practical Exercise Using the Database Engine Tuning Advisor 
3.2. Implementing the Database Engine Tuning Advisor recommendations 
3.3. Exercises


Recovery + Schema Tuning

5 maio 2017, 11:00 Bruno Emanuel Da Graça Martins

1 - Exercises about the ARIES Algorithm for Database Recovery

2. Schema Tuning
2.1. Denormalization by collapsing tables
2.2. Partitioning tables
2.3. Denormalization by adding redundant columns
2.4. Denormalization by adding derived attributes
2.5. Using materialized views in SQL Server
2.6. Using nonHclustered indexes over derived attributes in SQL Server
3. Experiments and Exercises
3.1. Experiments with SQL Server 
3.2. Exercises about Schema Tuning


Query Tuning

5 maio 2017, 09:30 Helena Galhardas

Query tuning through query rewriting:

  • Considerations on index usage
  • Eliminating DISTINCTs
  • Re-writing of (correlated) subqueries
  • Use/abuse of temporary relations
  • Considerations on join conditions
  • Use of HAVING
  • Use of views
  • Considerations on the usage of triggers.