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
-----------------------------------------------------------------------------