Re: force engine to use indexes

Yup, you are right on the button with the optimiser, unless you know your data, know what you are doing and have been around your engine for some time to know how it behaves, you aint gonna get it right. Sequential scans can a good thing, who puts an index on a tiny table? just asking for overhead. The boss is an ex-vax dude, ex-cobol and the suchlike. Writes some of the best code i've ever seen. And I've been around, Aways, he does remind me of the Dilbert manager :) Both of us dilbert fans, and his hair is fading so we don't mention it :) brett Andrew Hamm wrote: > > 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 -- ----------------------------------------------------------------- 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 -----------------------------------------------------------------