>I have the following situation. I have a table subscriber with a field called c_region_id and an index is built on it. When I perform a query for c_region_id = "WDC" I get only partial optimization when I run Sys(3054,11). Any ideas as to what I could be doing wrong.

Could you supply the actual SELECT statement(s) and the INDEX expression(s) on the field(s)?