SQLSACT (9/13/2012)
What I'm struggling to grasp is why does SQL Server still worry with the Index if all the pages that it needs is already in memory.Thanks
The index key values tell the database engine which pages to go read to get the required rows, if the page(s) is(are) not in memory then the engine will need to read them in from disk
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉