>Yes
>
>>Do you have DELETED() tags in both tables?
I don't understand why you don't get full optimization here. Surely, you have both tables indexed on MasterID? What about DELETED() tag name: it's recommended to not call it 'DELETED' itself and use other name.
It's minor points.
I hope some guys who use local p-views more than me will jump in here.
Edward Pikman
Independent Consultant