Hi

I have a large table with a status field and I want to select the records for a group os status's.
the table is indexed on the status

this can be done by

lcStatusList = 'AFTHEW'
SELECT* ;
FROM mytable ;
WHERE mytable.status $ ?lcStatusList

Unfortunately, this does not optimize.

Is there any way to fully optimize this query without expanding the Select to something like

SELECT* ;
FROM mytable ;
WHERE mytable.status = 'A' OR ;
	mytable.status = 'F' OR ;
	mytable.status = 'T' OR ;
	mytable.status = 'H' OR ;
	mytable.status = 'E' OR ;
	mytable.status = 'W'

regards
Geoff Scott