Re: FW: Sequential scan

Posted in 2001

Topics: Performance & Tuning, Jobs, Consulting & Announcements

Mark D. Stock — Tue, 30 Jan 2001 21:18:05 +0000 — source: Informix-list mailing list archive (1991-1998)

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 Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+

↪ replying to Mark D. Stock

Obnoxio The Clown — Wed, 31 Jan 2001 09:32:00 GMT — source: Informix-list mailing list archive (1991-1998)

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?

↪ replying to Obnoxio The Clown

Brett Randall — Wed, 31 Jan 2001 20:41:43 +1000 — source: Informix-list mailing list archive (1991-1998)

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? At least we know that you are "The Clown" up front. >8-) With some of the people I meet in my travels, I shortly realise "they are only missing the make-up and the red nose" ... BR