Re: Force index usage

Tim Kelly wrote: > Ok, how in 7.x can I force an index to be used in an SQL Select > statement? First the good news: This is a popular feature request at Informix. The bad news: Last I heard of it, Informix's attitude was to deny this kind of request. The optimizer should always be picking the best index for the query; if it does not, please report a bug. What happens then? Speculations anyone? It is possible that Informix will now claim "there is no ANSI standard way to instruct the engine on what index to use". This is correct, of course. Indexing is an implementation issue; the theoretical aspects of the database survive without indexes. Still, y'know, folks use the database to run a business and sometimes the heuristic rules in the optimizer *do* screw up. It would be helpful if Informix gave us a non-ASNI compliant way to set the optimizer straight. If we mess up for failure to keep statistics up to date, we'll accept the blame. Just give us that &^%$! feature!! Please.. Thanks for the steam valve, Tim. -- -- Jake (In pursuit of undomesticated aquatic avians) +----------------------------------------------------------+ |Aside from that, how did you enjoy the play, Mrs. Lincoln?| +----------------------------------------------------------+