Indices

8 março 2013, 13:30 • Helena Galhardas

• Indices in SQL Server: creation and impact on the query execution
• B+-tree insertion and deletion.

Indexes on SQL Server

8 março 2013, 11:00 • Bruno Emanuel Da Graça Martins

• Indexes on SQL Server
• Exercises about B+Trees
• Exercises about Extendible Hashing

Ordered indices (cont.) and Hashing

8 março 2013, 09:30 • Helena Galhardas

Ordered indices:

• Bulk loading and bottom-up build
• B-tree index files
• Multiple-key indices
• Covering indices

Hashing

• Static hashing
• Dynamic hashing: extendable hashing.

Ordered indices (cont.)

5 março 2013, 09:30 • Helena Galhardas

• Insertion and deletion in B+ trees.
• B+-tree file organization
• Record relocation and secondary indices
• Indexing strings.

Storage in SQL Server 2012

1 março 2013, 13:30 • Helena Galhardas

• SQL Server Databases and Database Files
• Inside Database Files
• Partitioning Logical Objects into Physical Parts.