Re: Informix Online 5.0 Query Optimizer

> > >Estimated Cost: 2447 > >Estimated Cost: 3583 Both numbers way to high. A sign that schema is perhaps not the most efficient for what you are trying to do. When I see numbers like that I tend to rewrite the query or revamp the schema to bring it down. Something you may consider, which I forgot to verbalise the other day, is doing a UNION instead of an OR. I've seen this bring 'costs' down from the multi-k into the twenties. j. _____________________________________________________________________________ Jack Parker - Contractor | Hewlett Packard, BSMC Boise, Idaho, USA| If you keep staring at it like that, jparker@hpbs2561.boi.hp.com | your nose is going to grow (208) 396-5388 (W) (208) 384-1623 (H) | into the bark. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________