Comp 305-001/405-001: Database Administration
Spring 2024: MWF
Week 10
Query
optimization
Window functions
select lname, count(*) over (partition by super_ssn), sum(salary) over
(partition by dno) from employee;
Wednesday
explain
in Postgres
Very
Slow Query
Normalization
Transactions