RE: seq. scans

Posted in 2000

Scott Black — Thu, 4 May 2000 08:59:29 -0400 — source: Informix-list mailing list archive (1991-1998)

Keeping in mind that sequential scans are not necessarily a bad thing... If you're trying to retrieve nearly every row anyway, a sequential scan is the best way to go. -----Original Message----- From: Obnoxio The Clown [mailto:obnoxio@hotmail.com] Sent: Thursday, May 04, 2000 5:55 AM Posted To: informix Conversation: seq. scans Subject: Re: seq. scans From: Marat <maratkotik@mail.ru> > >Good day Experts, > >Is increasing of BUFFERS and building indexes only way to descrease >seqscans? I don't know that increasing BUFFERS will do anything. UPDATE STATISTICS minght help. :0) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com