First,I haven't heard anything about BUFFER_POOL KEEP
clause. Am I missing something here?
Secondly, when you say CACHE when creating a
table(recommended for small tables), your SGA will
cache the table which will make data retreval faster.
Lastly, I haven't heard anything such as creating
INDEX
with CACHE spec. Am I missing something here too?
- Andrey Bronfin <bronfin_at_VisualTop.com> wrote:
> Dear DBAs !
>
> Could U please clear the following for me :
>
> 1) What's the difference between creating a table
> with storage ( BUFFER_POOL KEEP) vs . creating a
> table with CACHE specification ?
>
> 2) Is it possible to create an index specifying
> CACHE ? ( I did not succeed so far and i don't have
> a doc to look at ) .
>
> Thanks a lot in advance !
>
>
>
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
Received on Tue May 16 2000 - 15:01:23 CDT
