Re: Urgent: Q on loading table into memory

Posted in 1999

Vardan Aroustamian — Tue, 17 Aug 1999 10:14:52 -0500 — source: Informix-list mailing list archive (1991-1998)

SET TABLE your_table MEMORY_RESIDENT; SET TABLE your_table NON_RESIDENT; You can set resident only particular fragment of fragmented table SET TABLE your_table ( dbspace1, dbspace2 ) MEMORY_RESIDENT; HTH Vardan RVASUDEV wrote: > > Hi, > > What is the Informix SQL command to load a table into memory ? > > TIA > Vasudev -- vaar@geocities.com