Indexes and Execution Plans

Presenter: Kim Tessereau

Session Details

This session will offer examples of B-Tree indexes, as well as offer an introduction to the query optimizer. It will cover obtaining execution plan information, queries that use join operations and lastly, myths about optimizing and indexes.

About the Speaker

Kim Tessereau MCDBA & former MCT: has 28 years of IT experience with 15 years of experience with databases and 7 years of teaching. She has worked as a Sybase, Oracle and SQL Server DBA and developer. She currently works at Scottrade as a Senior Database Developer and spends time mentoring junior members of the group. Kim also works as an instructor at Washington University in St. Louis - CAIT teaching Business Intelligence and Database Administration courses.