If invcust table doesn't have index on DELETED(), SYS(3054) will report partial optimization in both BFP8 and 9.

>

SELECT *;
> FROM ;
>     wots!invcust;
> WHERE  Invcust.custinvno == ( ?lnCustinvno )

>
>

Using index tag Custinvno to rushmore optimize table invcust
>Rushmore optimization level for table invcust: Partial

>
>

>Order Name  Type       Expression    Filter     Collate
>Custinvno   Candidate  custinvno                Machine

>
>