Comp 305-001/405-001: Database Administration

Spring 2024: MWF

Week 9


Indexing

    B-trees

Wednesday:

Dell assignment

Explain

    Start with joins
    Dell assignment

Friday:

Avoid distinct in select clauses unless you really need it. Though sometimes you do.
Avoid unnecessary tables in joins.

Query Trees and Query optimization

    Join algorithms
    index selection


Very Slow Query

Window functions

Normalization

Transactions