table/index memory_residency

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

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

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 >