Re: The dreaded sequential scan

Posted in 1996

Sanjay Kumar — 28 Mar 1996 18:43:14 -0500 — source: Informix-list mailing list archive (1991-1998)

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