STAREAST 2025 - Performance Testing

Wednesday, April 30

VISA USA, INC
W4

SQL Server Indexing Strategies Using Query Store for Improved Performance in Retrieving Data

Wednesday, April 30, 2025 - 11:30am to 12:30pm

In the realm of database management, optimizing query performance is crucial, especially for SQL Server environments dealing with large datasets. The challenge lies in identifying and implementing effective indexing strategies that can significantly enhance data retrieval performance. During her talk, Navya will address the common issues of slow query performance and inefficient indexing, often exacerbated by the complexity of modern data systems and the dynamic nature of query patterns. To tackle this problem, she leveraged SQL Server's Query Store feature, which provides a powerful tool...