Ok, I checked the manuals, zip.
the sql command set table n memory_resident, does that
make the indexes resident aswell? or just the data pages?
I see there is a set index n memory_resident aswell
brett
↪ replying to bob
bob wrote:
>
> Ok, I checked the manuals, zip.
>
> the sql command set table n memory_resident, does that
> make the indexes resident aswell? or just the data pages?
>
> I see there is a set index n memory_resident aswell
You have to mark table data pages and index pages resident separately
if that is what you want.
Art S. Kagel
↪ replying to Art S. Kagel
Thanks, working apps to do that now, but a quick question,
aside from onstat -P how do I determine if table/index
has been set resident? I checked sysmaster and no sign
there
brett
> > the sql command set table n memory_resident, does that
> > make the indexes resident aswell? or just the data pages?
> >
> > I see there is a set index n memory_resident aswell
>
> You have to mark table data pages and index pages resident separately
> if that is what you want.
>
> Art S. Kagel
>