Re: The dreaded sequential scan

Posted in 1996

Sanjay Kumar — 29 Mar 1996 09:38:30 -0500 — source: Informix-list mailing list archive (1991-1998)

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