Query Execution in SQL Server

24 março 2017, 11:00 • Bruno Emanuel Da Graça Martins

1. Exercises about Extendible Hashing (continuation from previous lab)

2. Important Concepts about Query Execution

2.1 Basics of Query Processing in SQL Server

2.1.1 Full Table Scans

2.1.2 Index Scans and Seeks

2.1.3 Nested Loop Joins

2.1.4. Merge Joins

2.1.5. Hash Joins

2.2 Particular aspects of Query Processing in SQL Server

3. Exercises and Experiments

3.1. Experiments with SQL Server

3.2. Exercises

Query Processing (cont.)

24 março 2017, 09:30 • Helena Galhardas

The Join Operation

• Nested loop join
  
• Block nested loop join
  
• Index nested loop join
  
• Merge join
  
• Hash join
  

Query Processing (cont.)

24 março 2017, 09:30 • Helena Galhardas

The Join Operation

• Nested loop join
  
• Block nested loop join
  
• Index nested loop join
  
• Merge join
  
• Hash join
  

Query Execution in SQL Server

24 março 2017, 08:00 • Bruno Emanuel Da Graça Martins

1. Exercises about Extendible Hashing (continuation from previous lab)

Query Processing

21 março 2017, 11:00 • Helena Galhardas

• Introduction to query processing
• Measures of Query Cost
• Selection Operation
• Sorting.