Re: The dreaded sequential scan

Posted in 1996

Andy Calverley — Mon, 01 Apr 1996 14:25:51 -0800 — source: Informix-list mailing list archive (1991-1998)

Sanjay Kumar wrote: > > Cheryl wrote ------ > 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. > > I dropped the table , recreated it and loaded the data back. > Then ran update statistics high for the column we r searching on and > the result has been good. I saw the index path being used in the > set explain results.> > Thanx for your help > ____________ > Sanjay Kumar Email: skumar@raileurope.com > Rail Europe Inc. > 226 Westchester Ave | Office : (914) 681 3296 > White Plains, NY 10604 | Fax : (914) 682 5236 -- Andy Calverley Internet: andy@dcc.govt.nz MIS Technical Support Dunedin City Council PO Box 5045, Dunedin, New Zealand