Categories
Sql Server

How Data Is Accesses In Sql Server

SQL Server first determines existence of a  index. Then query optimizer—the component responsible for generating the optimal execution plan for that query— then it determines is scanning a table or using the index is more efficient for accessing data. SQL Server accesses data in one of two ways: By scanning all the data pages in […]