Question
1
Replies
272
Views
SFWMD
Posted: 4 years ago
Last activity: 4 years ago
Quiz
What is the correct answer for the following CSA question.
The Property Optimization wizard is used to:
A. Create properties in a data class
B. Store properties in the BLOB to reduce database table space
C. Store properties on the clipboard more efficiently
D. Improve report performance
ANS D:
but most of the places I saw answer as C still confused.
***Updated by Moderator: Vidyaranjan| Moved from PSC***
Posted: 4 years ago
Hi,
when property optimisation is covered on the course, it is under the reporting lesson.
The purpose of property optimisation is to improve report performance. If you create a report on a non optimised property, you will have a performance warning in your rule.
In fact why the answer is D is because it is the exact opposite of B.
During the process (population) you will create an extra column in the table so the report does not have to parse the BLOB and can query directly on columns. Improving performance.
Damien