|
-
If the table is not frequently updated and inserted, keeping the data in BUFFER POOL KEEP is the right choice. Please remember you need to have more memory, because DB_BLOCK_LRU_LATCH needs memory to maintain the KEEP buffer cache.
RECYCLE is another place when the table is very rarely updated or inserted.
If you are in shortage of memory, ALTER the table with CACHE parameter. This will keep data buffer in MRU of LRU list.
Today memory board is not costly, buy as much memory as you can. That will help you in the long run.
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
|