#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