As data begins to scale (even before you get to Big Data, but especially then), database performance is often directly proportional to the quality of your index selection. Proper indexing has often taken multi-hour and multi-day queries to seconds and minutes.
This discusses index structures, how they are used by the optimizer, and how to properly select indexes for optimal query performance. Jeffery Garbus will share his experiences, teaching the techniques that enables him to reduce multi-hour queries to seconds with this informative session.
All good developers and DBAs know that indexes are critical to the performance of a well-behaved database, but you might be surprised just how little many people know about how indexes work and why what may appear to be a trivial indexing mistake can actually result in catastrophic query performance.
Many performance issues can be easily and quickly resolved by adding or changing indexes. This session talks about how to choose indexes based upon query needs with an understanding of physical index structure.
Who should attend?
Jeffrey R. Garbus
Jeffrey R. Garbus’s background includes a B.S. Degree from Rensselaer Polytechnic Institute, and work experience from PC's to Mainframes and back again. Jeff has many years of client / server, Sybase, and Microsoft SQL Server experience, with a special emphasis on assisting clients in migrating from existing syst... More info