Sql server indexing10/31/2023 ![]() ![]() When we design an index for a query, optimizer will utilize the defined index to generate the plan for requested query if the index has low cost based on performance of query. SQL Server optimizer is a cost based optimizer so it picks the index which has low cost based on performance. ![]() SQL Server query optimizer decides which index to use, when a query is requested.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |