Perry Whittle (9/25/2012)

---

SQLSACT (9/25/2012)

---

Hi all

I have a quick question regarding pages moving from disk into memory

If I select * from a table, are all pages that make up the table and indexes moved into memory?

So any subsequent query against that same table would not need to go to disk at all?

Thanks

for select * there is no index and yes, all data pages would be cached into memory