FW: FW: Sequential scan

From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of Obnoxio The Clown Sent: Wednesday, January 31, 2001 11:32 AM To: informix-list@iiug.org Subject: Re: FW: Sequential scan 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? True, a couple of times I wanted to mention some of your comments to my managers, but didn't because they would ask me who it's from, and I couldn't tell them, like you say, "Oh, I got it from Obnoxio the Clown !"