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
- Delivered Redundant Indexes @ 59:00