Indexes are intended to provide faster access to rows when querying data than would a full scan of the entire table. In a perfect database world, indexes would always match our queries. Dream on. 

The real database world is full of chaotic queries, and a misguided index strategy can destroy performance along with your sanity. 

Join Karen Morton, Oracle ACE, and Embarcadero’s Scott Walz as they discuss strategies and techniques to create highly effective indexes.
 
Register for the webinar to learn:
  • How indexes are structured and how they function
  • How multiple indexes per table increase resource overhead
  • How to quickly identify index inefficiencies
  • Strategies for implementing the best mix of indexes in your environment


Hit Autopilot & Find Better Ways to Utilize Database Indexes
Effective Database Indexing: How to leverage Database Indexes for Optimal Performance

About the presenters:

Karen Morton

Karen Morton is a consultant and educator specializing in Oracle performance optimization in both shoulder-to-shoulder consulting engagements and classroom settings. She is an Infrastructure Principal Director for Accenture Enkitec Group, a global systems integrator specializing on the Oracle platform.

For almost 30 years, Karen has worked in information technology. Starting as a mainframe programmer and developer, she has been a DBA, a data architect and now is an author, researcher, educator and consultant. Having used Oracle since the early 90's, she began teaching others how to use Oracle almost 20 years ago.

Karen is a frequent speaker at conferences and user groups, an Oracle ACE, and a member of the OakTable network. She blogs at karenmorton.blogspot.com.

Scott Walz

Scott Walz has more than 20 years of experience in the area of database development and currently serves as the Director of Software Consultants for Embarcadero Technologies.  Prior to joining Embarcadero 12 years ago, Scott served as a development lead for Louisville Gas & Electric. He holds a bachelor's degree in computer information systems from Western Kentucky University.