Re: FW: Sequential scan

we become O#$%(* staff ? brett Obnoxio The Clown wrote: > > In the year of Our Lord Tue, 30 Jan 2001 21:18:05 +0000, "Mark D. Stock" > <mdstock@mydas.freeserve.co.uk> spake, saying: > > >Mark Griebling wrote: > >> > >> Hi Dirk, > >> > >> It was just a suggestion. Just try it and if it doesn't work - drop the > >> index. In my experience the Optimizer is not always so bright. If it works > >> and does the job - what's the harm? > > > >1. Increased disk usage > >2. Inserts run slower > >3. Updates run slower > >4. Deletes run slower > >5. Query optimisation runs slower > >6. Flash consultants can come in and tell you about your duplicate > > indexes. > >7. Your boss laughs when you say you got the advice on a news group > > from a guy called Mark. :-O > > I'd say you're a marked man now. > > But what about people who have to tell their boss they take advice from Obnoxio > the Clown? -- ----------------------------------------------------------------- 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 -----------------------------------------------------------------