SQL PASS Detroit

January 2018

Black Arts Indexing: A Science and an Art
You already know that good table design and proper indexing go hand-in-hand with writing high performance code, but do you know how indexes work under the hood? This is an in-depth look at indexing, and starts by examining the mechanics of pages, index structure and seeks versus scans. Then we'll discuss the inner workings of clustered and nonclustered indexes. Lastly, we'll look at covering indexes, heaps and over-indexing.

This presentation will illustrate why understanding index structure is so very important. We'll learn why some indexes can hurt performance while others will make your code scream. We'll take on the classic myths of “seeks always being better than scans” and that “duplicate indexes are always bad”. We’ll also examine why too many indexes can hurt performance.

Speaker Bio: Ed Wagner
Ed's a Senior DBA and SQL mentor at Ipsos RDA with 25 years experience as a developer and DBA. He's the president of the the SQL PASS in Detroit (SPID) chapter and a frequent poster and guest author on sqlservercentral.com. Ed has spoken at several local PASS chapters and SQL Saturdays. He's passionate about high-performance and "black arts" SQL and actually enjoys it.

Powerpoint Presentation and Code (.zip 922 KB)

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids