Hi,

This will do a full table scan as you are checking a field for not null condition.

Baliga