Re: The dreaded sequential scan

Posted in 1996

Roy Gvirtsman — Mon, 1 Apr 1996 15:31:40 GMT — source: Informix-list mailing list archive (1991-1998)

SOHO!dpsanjay@whitestone.raileurope.com (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 Is the sequential scan being done as a preperation phase for a hush join ? (see sqexplain.out after SET EXPLAIN ON) If so, try to set OPTCOMPIND to 0 on onconfig or better in your environment to disable hush join as a default on per session, respectively.