The NOCACHE option specifies that the blocks retrieved for the table are placed at the least recently used end of the LRU list in the buffer cache when a FULL table scan is performed. This will cause the blocks read with a full table scan to be immediately flushed from the buffer cache. If you don’t go after what you want, you will never have it.

Understanding the Context

If you don’t ask, the answer will always be no. If you don’t step forward, you’ll stay in the same place. Three sentences. Three ...

Key Insights