Re: Re Query Taking Too Long

Posted in 1996

Billy Wheeler — 12 Mar 1996 06:23:12 -0500 — source: Informix-list mailing list archive (1991-1998)

At 11:34 AM 3/11/96 -0500, Peter Wages wrote: > General question. Since it is relatively fast to make an index. In >this case a half hour. Can't informix automatically make an index >when it is optimizing a query? A temporary index for example? Uh, I think, uh, if Informix creates a temp table it'll index it if needed. I dunno about temp indexes on "real" tables. -- Cheers, Billy. ----------------------------------------------------------------------------- billy.wheeler@pixie.co.za +27 11 803 2151 p.o. box 3463, rivonia, rsa, 2128 +27 83 250 2324 "Have you got it yet?" (c) Kitsch 'n' Sync Productions 1996 -----------------------------------------------------------------------------