Re: force engine to use indexes

> Trust your optimiser Luke... Ya, heard that before, under 5.x, 7.24 and probably 7.31 (havn't tried) yet, we have found that how we build the queries ie. how the joins ordered thru the query makes a phat difference to the performance of a query. brett > Until you study the entertaining subject of how it works, don't try to > assume you know better ways of performing queryies when compared to guys who > have been doing it for many years - ie the guys maintaining the engines. Tell that to my IT manager who beats me with a calendar whenever he sees any of my queries that he can optimise brett -- ----------------------------------------------------------------- Brett's 12th law of UNIX administration... People tend not to react well when they lose control over their computers. Typically, it brings out the worst in them ... ----------------------------------------------------------------- Brett Geer - UNIX Admin/Analyst/Programmer - Intratex Holdings. Tel. +27 31 717 4000 Direct. +27 31 717 4146 Fax. +27 31 717 4001 ----------------------------------------------------------------- The little voices are talking to me again, telling me to reach for a keyboard and type rm -rf /* last week they had me rm -rf `echo $MANPATH | sed 's/:/ /g'` now I fear I have no answers -----------------------------------------------------------------

You've got to know what's going on before you can do better is all I'm saying. If you don't even know that sequential scans can sometimes be good, then I'd say it's Optimising 101 course that's needed first. Sounds like your boss has studied the science? Unless he always does a bad job?-) Does he beat you with a Dilbert Calendar? What does his hair look like? Brett Geer wrote in message <95b0lb$pne$1@news.xmission.com>... > >> Trust your optimiser Luke... > >Ya, heard that before, under 5.x, 7.24 and probably 7.31 (havn't tried) >yet, we have found that how we build the queries ie. how the >joins ordered thru the query makes a phat difference to the performance >of a query. > > >> Until you study the entertaining subject of how it works, don't try to >> assume you know better ways of performing queryies when compared to guys who >> have been doing it for many years - ie the guys maintaining the engines. > >Tell that to my IT manager who beats me with a calendar whenever he >sees any of my queries that he can optimise