Posted: 3 May 2016 18:19 EDT Last activity: 10 May 2016 11:24 EDT
Optimize for reporting
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.