Re: Online Dynamic Server 7.3 : Index not used!

David Van Wallendael wrote: > > Hello Everybody! > > I've recently migrated my unix server with the informix online 5.0 to > informix dynamic server 7.3. My problem is this : When i make a simple > query on a table, the index are not used > > Here's my table "fiche_ft" with the index : > > Column name Type Nulls > > fi_nume integer yes > fi_zone char(3) yes > fi_mot varchar(50,0) yes > > Index name Owner Type Cluster Columns > > ft1 informix dupls No fi_nume > > ft2 informix dupls No fi_mot > > ft3 informix dupls No fi_zone > > Here's the file sqexplain.out : > =================== > > QUERY: > ------ > SELECT ft.fi_nume FROM fiche_ft ft > WHERE fi_zone != '4a' AND fi_mot LIKE 'ethos%'> > Estimated Cost: 8888 > Estimated # of Rows Returned: 44593 > > 1) informix.ft: SEQUENTIAL SCAN > > Filters: (informix.ft.fi_zone != '4a' AND informix.ft.fi_mot LIKE > 'ethos%' > > As you can see , the index are not used... > > Did someone had already the same problem ? > Did someone has an idea how to force the use of index ? > > thanks, > > David Van Wallendael > www.irislink.com Make sure that you run 'update statistics' as recommended within the release notes. Just a simple "update statistics" may not be enough. -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */