Re: The dreaded sequential scan

Posted in 1996

Cheryl Kendricks — 28 Mar 1996 22:33:25 -0500 — source: Informix-list mailing list archive (1991-1998)

After update stats! And you still are getting sequential scan, sounds like you may want to re-execute the query using "SET EXPLAIN" and evaluate the results. ------------------------------------------------------------------------- Cheryl Kendricks Internet: cherylk@spamis.jcdc.doleta.gov OR cherylk@prod1.jcdc.doleta.gov OR kendric@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On Thu, 28 Mar 1996, Sanjay Kumar wrote: > > Hi, > > We have a similar situation in our project. The server 7.1 seems to be > doing a sequential scan for queries which r index based. I called Informix > and they gave me the same answer. > > I updated statistics for the table and columns in low , medium and high > all possible cases but to no avail. > > TIA > ____________ > Sanjay Kumar Email: skumar@raileurope.com > Rail Europe Inc. > 226 Westchester Ave | Office : (914) 681 3296 > White Plains, NY 10604 | Fax : (914) 682 5236 > >