Re: Online Dynamic Server 7.3 : Index not used!
David Van Wallendael wrote:
> 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%'
1. Change filter condition from "fi_mot LIKE 'ethos%'" to "fi_mot[1, 5] =
'ethos'".
2. Take into consideration message from June Tong.
3. UPDATE STATISTICS HIGH FOR TABLE fiche_ft ( fi_mot );
> David Van Wallendael
> www.irislink.com
Leonid Vorontsov
www.dati.lv