SQL tuning isn’t easy! Take, for example, Dave the DBA. He adds an index to a table to improve a report query that takes more than an hour to run. Now it takes 10 minutes. Dave is a hero. But not for long. Later in the week, he'll find himself troubleshooting a few weekend jobs that suddenly run much longer than normal. The culprit? Yeah, that new index. Sound familiar? If so, you’ll enjoy this webcast. We’ll explore the question: why is it that finding optimal indexes or optimal SQL plans is so difficult?
Quest Software Solutions Consultant Gary Jerep will present insights to help you appreciate why query and index performance tuning gets so difficult on relational databases. You’ll also see how much easier index performance tuning is with a productivity solution called Toad.
Referenten
- Gary Jerep, Quest Software
- Stephen Faig, DBTA