How to cache a non-unique index?
Started by Xin Wangabout 16 years ago2 messages
Hi,
I have added a catalog table with an index on a non-unique column. I
want to cache this non-unique index like other unique indexes in
syscache. Is there any way to cache a non-unique index? I just want the
index to reside in the memory to speed up the index lookup. Thank you!
Wang
Re: How to cache a non-unique index?
Xin Wang <andywx@gmail.com> writes:
I have added a catalog table with an index on a non-unique column. I
want to cache this non-unique index like other unique indexes in
syscache. Is there any way to cache a non-unique index?
No, not with syscache.
regards, tom lane