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