I do understand that if i create any case that is stored as BLOB field in the pega database table. If i do need to use any of the fields in the report i have optimize the field (exposing the field). Why do we need to optimize? what happens in the background if i optimize the property?
Retrieving/Extracting any property field value from the BLOB column is a costly DB operation and hence not recommended for reporting. Optimizing the property(exposing) creates a separate DB column on the particular table for faster access.