Re: Informix Optimiser: Should I use it?

In article <4i6sc0$r4m@ns.oar.net> william@carsinfo.com (William Harris) writes: >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. Bad idea, IMHO. Progress does this - enables you to specify the index to use in a query. Guess what happens when (NOT if) some bright DBA changes the name of the index? Better to use EXPLAIN and tune your indexes. I'm very grateful this feature ISN'T in Informix; it's caused me a lot of grief. I now have the schema locked exclusive to me only :). Peter Wiley