Re: caching indexes
From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Wed, 31 Jul 2002 01:30:28 GMT
Message-ID: <U4H19.95773$uh7.15475_at_sccrnsc03>
Date: Wed, 31 Jul 2002 01:30:28 GMT
Message-ID: <U4H19.95773$uh7.15475_at_sccrnsc03>
As you use the index it will get cached.
Jim
"Vissu" <vissuyk_at_yahoo.com> 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
Received on Wed Jul 31 2002 - 03:30:28 CEST