Re: OnLine Optimizer with compound indices??

Posted in 1995

"Andy Kent" — Mon, 13 Mar 1995 23:30:18 GMT — source: Informix-list mailing list archive (1991-1998)

> You may get a better result from creating a second > index on (b,a) and using a UNION. No need to use a UNION. Just the presence of a separate index for each side of the OR will do the trick. akent@cix.compulink.co.uk (Andy Kent) ------------------------------------------------ Freelance Informix Database Specialist, Redland, Bristol, England