Re: Index on IUS :-)

Posted in 2000

Madison Pruet — Mon, 03 Jan 2000 22:17:29 -0600 — source: Informix-list mailing list archive (1991-1998)

You can't, but why would you want to? Detached indexes have a performance advantage over an attached index in a multi-processor/multi-user environment. Scans don't have to skip over pages. FYI - the main reason that this is done with IUS is because of table inheritance. Sanjit Chakraborty wrote: > In IUS all indexes are detached index by default. How can I create a > attached index? > > Thanks, > Sash