|
-
Re: FULL Hint not working
Originally posted by jodie
I thought full table scans didn't keep the data in the cache, just enough from one Multi-block-read count.
Ah, not so ... the blocks get placed at the Least Recently Used end of the LRU list in the cache, but they still get cached.
This behaviour can be changed with the CACHE hint, although that's obviously not relevant to your case.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|