Re: Informix Optimiser: Should I use it?

The optimizer can be very stupid. I would love to have some sort of clause in a statement that would force it to use a certain indexing strategy - "select name from id_rec using id_prim" or something like that. But on balance, the optimizer does not go off the deep end that often. To deliberately disable use of the optimizer is, IMO, a poor database design decision. -- William Harris william@carsinfo.com CARS Information Systems 4000 Executive Park Drive Cincinnati, OH (USA) 45241