Aqua Data Studio

Geek Sync – Understand Indexes to Write Better Queries

It’s relatively easy to learn how to query a database for information. SQL is a declarative language, meaning we simply tell the engine what to get, not how to get it. Some queries are fast, others are slow. We’ve all heard that an index will make the query faster, and often the solution to performance problems are indeed indexes. Why is that? What are they? How do you use them? With a good understanding of what indexes are and how the engine uses them, and by writing our queries with indexes in mind, we can make queries perform much faster.

In this session we’ll learn index basics and how to write queries that can take advantage of them for more efficient, better-performing queries.

Speaker: Janice Gerbrandt has been designing and implementing database solutions to improve business functionality since 2001. She is an active PASS member and leads her local user group and a virtual group, as well as organizing SQL Saturday Victoria.

Webcast Form

  • You can always update your communications preferences later.
    AquaFold may share your information with its subsidiaries and its partners. For further details on how your data is used and stored, please review our Privacy Policy
  • Note: By registering, you confirm that you agree to the processing of your personal data by AquaFold, Inc. - AquaFold as described in the Privacy Statement. AquaFold, Inc. - AquaFold is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.