Re: Force index usage

In article <3385cf02.28251463@gate.idg.no>, Nils.Myklebust@idg.no writes: > :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. > > [ stuff snipped about it being an "advantage" to *not* be able to > force an index ] > I find your argument unconvincing because even though I agree with the academic nature of your points, the fact of the matter is that software has bugs. Why *wait* for Informix Inc. to *fix* the bug and have you jump through all sorts of gyrations rather than letting the SQL coder place a fix in until Informix Inc. can get their problem fixed? This way you have the best of both worlds: a good optimizer and real-world realization that software has bugs and that an RDBMS vendor needs to *help* the developers to "get the job done." -- Pablo Sanchez | wk: 415.933.3812| pg: 800.930.5635 -or- pablo_p@pager.sgi.com --------------+-----------------+-------------------------------------------- pablo@sgi.com ... when mailing me, place "not spam" in the Subject