|
|
| Re: caching objects [message #58361 is a reply to message #58360] |
Tue, 19 August 2003 04:47  |
Deepa
Messages: 269
Registered: November 2000
|
Senior Member |
|
|
u can use Multiple buffer pool feature to cache tables.
you need to alter the table and specify STORAGE ( BUFFER_POOL KEEP)
or else
Alter table tablename cache ;
that will pin the table in the buffer cache .
In the create table statement if cache option is enabled, then the blocks retrieved from the table during full table scan are placed in the MRU end of the LRU list. but will not be permanently pinned in the buffercache.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
