Re: caching indexes

vissuyk_at_yahoo.com (Vissu) wrote in message news:<2bedd6a7.0207300858.4da32e8b_at_posting.google.com>...
> Hi All,
>
> I was wondering how to cache indexes. If it is a table, we can add
> the CACHE clause. If I want to keep it in the keep pool, I could issue
> a command so that it is in the buffer keep pool.
>
> I have no idea how to cache an index. Can someone help me with this.
> We are using 92. I am also thinking of partitioning the index
> (opposed to global index and cache only the partition that is queried
> the most).
>
> Thanks for any help
>
> Vissu

You can manually cache it if you want, but as blocks are read from the disk into memory, they are kept there as long as they don't age out. If certain blocks are queried frequently, they will likely remain in the SGA. Received on Sun Aug 04 2002 - 18:29:06 CEST