Re: informix does not use indexes?
Hi,
If you want to force the Informix engine to use the index on 'col4', then
try this :
select * from table --+INDEX(index_name)
where col4 = 2;
Hope this helps.
Suhas
------------------------
From: ProzessDV <prozessdv@aol.com>
Subject: informix does not use indexes?
Date: 22 Oct 1998 08:45:15 GMT
Location: news://news.alterdial.uu.net/comp.databases.informix/19981022044515.03961.00004046@ng34.aol.com
To: "comp.databases.informix" <@news:comp.databases.informix@news.alterdial.uu.net>
OWS 7.22 on SCO UNIX:
The following SELECT-statement in dbaccess takes a long time until I get a
result , although I have declared an index on col4 (the table "table" has about
400000 rows). But when I use "set explain on" and look at the output of this
statement, I see that there is no index used for the search, just SEQUENTIAL
SCAN. I also tried to set optimization high or low.
select * from table where col4 = 2
Are there any options to set so that informix uses indexes, maybe?
---------------End of Original Message-----------------
--------------------------------------------------------
Name : Suhas Tembe
E-mail: <stembe@arrowshirt.com>
Phone : (404)-346-5687
Fax : (404)-346-5540
Date : 10/22/98
Time : 15:57:21
Place : Atlanta, Georgia.
--------------------------------------------------------