#82 - Database Statistics w/ David Kurtz

This week David Kurtz joins us to talk about Database Statistics,
his PS_GFC_STATS package, the PSCBO package, identifying
redundant indexes and more. David also gives insight into why he
created PS_GFC_STATS and how it compares to the PSCBO package.
Show Notes

Database Stats @ 1:00

Maintaining Statistics @ 7:45

PS_GFC_STATS Package @ 14:00

PSCBO Stats Package @ 18:15

Why Choose PS_GFC_STATS over PSCBO @ 26:15

Implementing PS_GFC_STATS @ 33:45

Statistics History @ 37:30

DDL Triggers with PS_GFC_STATS @ 42:00

Carlos Sierra and EDB360

PS360 • Redundant Indexes @ 43:45

Removing Unnecessary Indexes: 1. The Need for Extended
Statistics

Removing Unnecessary Indexes: 2. Identifying Redundant
Indexes

Removing Unnecessary Indexes: 3.Cost of Maintaining
Indexes

Identifying Redundant Indexes in PeopleSoft

Removing Redundant Indexes in PeopleSoft



Delivered Redundant Indexes @ 59:00