Today I’m back in the home office, finishing up teaching Mastering Index Tuning and getting ready to head out on a Mexico cruise. Let’s go through your top-voted questions from https://pollgab.com/room/brento.
Here’s what we covered:
00:00 Start 00:30 Need For Speed Round: What do you recommend for statistics maintenance on TB-scale tables with billions of rows? We’ve gone 5 years with neither scheduled nor automatic statistics updates and it hurts. WITH SAMPLE 1 PERCENT is many millions of rows. 03:43 CantSayWithoutThemKnowing: Hi Brent, long time listener/supporter. Are you seeing a battle starting between experienced DBAs vs a AI