>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.

If you have SET DELETED ON, you need to add an index on DELETED() to get full optimization. If you SET DELETED OFF you can get full optimization with an index only on c_region_id.