I have done some mock exam questions regarding optimizing the correct columns for reports and I get them incorrect every time! I presumed they would be the values that change often that require them to be optimized. Are mock exam answers always correct? I presume this is part of CSA but it was only really skim covered in the videos.
Can somebody please point me in the right direction as I don't believe SAI and SAII videos as adequate?
you want optimise properties for reporting. You want to optimise properties that are used often in reports.
When you create a report definition in order to query the DB, it is time consuming to retrieve the BLOB, parse it and get the value for the properties. Which is why you can optimise these properties, by doing so, a new column will be created in the table so you requests (reports) can point directly to columns to fetch data instead of using the BLOB.
To prepare the CSA exam there is only the videos, transcripts for each videos and the reference document (student guide) available in the first lesson of the first module.
I have done more research... We are optimizing properties that are modifiable through the interfaces and not system generated properties such as dates and ID's. If this is correct this was not as clear in the material.
That is correct. Many system generated properties are already optimized. From the Designer Studio>Data Model>Classes and Properties>Data Base Class Mappings and open one the classes that represents a case, you will see the pre-exposed Pega defined Properties.