Re: Stored Procedure: Sequential/Index Search

Santram How large is the table? If it is small (less than 2 pages), Informix figures that it is more expensive to use the index (1 data page + 1 index page at least), and does a seq scan. HTH Sujit santram <santram@ix.netcom.com> on 09/03/99 08:03:08 AM Please respond to santram <santram@ix.netcom.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Stored Procedure: Sequential/Index Search In stored procedure, I have a select stmt which retrieves data from a single table. Also, there is an index on all columns which I am going after in where clause. When execute, data is read sequentially instead of using index. I have tried with SET OPTIMIZATION LOW/HIGH/MEDIUM. But still fetching sequentially. Is there anyway I can force this select stmt to retrieve rows using Index and not sequentially? Please reply your suggestions at rajd@ialtd.com