If the original index wasn't filtered, you should have been able to use it for optimization rather than creating two new indexes on your table. Oh, well, at least you have it working now.

>>Was there a filter on your index, or did you end up creating an index on both CustID and PoNum individually?
>>
>>Jonathan
>>
>>>>Try creating two more indexes, one on CustID and one on PoNum.
>>>
>>>Of course...that does it
>>>
>>>Thanks for your quick replies
>
>There was no filter...creating 2 indexes did it