Question
2
Replies
6206
Views
infosys ltd
Posted: May 3, 2016
Last activity: May 10, 2016
Closed
Solved
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?
Message was edited by: Lochan to add Category
Hi Vimala,
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.
For more info, please refer to:- https://pdn.pega.com/sites/pdn.pega.com/files/help_v718/procomhelpmain.htm#tools/propertyoptimization/aboutpropertyoptim…
BR//
Harish