Home -> Usenet -> comp.databases.oracle -> caching indexes

caching indexes

From: Vissu <vissuyk_at_yahoo.com>
Date: 30 Jul 2002 09:58:09 -0700
Message-ID: <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
Received on Tue Jul 30 2002 - 18:58:09 CEST












Original text of this message