In this on-demand session, Oracle ACE Director Janis Griffin and Senior Data Architect Eric Blinn discuss how to use SQL Server indexes to make your queries run faster.
You’ll gain expert insights to understand how indexes can help. You’ll also learn about various methodologies to determine which SQL Server indexes improve performance the most -- as indexing every column is not the answer!
Janis and Eric will show you how to use SQL Server index options, such as filtering and compression, as well as different types of indexes, like rowstore and columnstore. These can be extremely beneficial in specific use cases. You’ll learn what those use cases are and how to index them for blazing-fast query execution.