Is Probe Bitmap a problem here showing as residual predicate?
I am tryting to tune one of the SP's running in parallel. Somehow have achieved to reduce the time from 2 mins to 20 seconds, but still thats slow compared to few 100 records as output.
So in the execution plan i see a warning , for predicate for Probe BItmap.
I am really not sure if that is casuing an uneeded scan or a real problem here.
Please suggest if there is a way i can tune this further.