Is Probe Bitmap a problem here showing as residual predicate?

SQLDB 2016-07-26 14:13:43

Hi,

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.