Which technique is most likely to improve query performance?
A.
Set the auto-sort property to maximum.
B.
Set the detail aggregation to 'Calculated' for measures.
C.
Avoid functions in filters.
D.
Add more joins between queries.
The Answer Is:
C
This question includes an explanation.
Explanation:
Query Performance: Enhancing query performance involves various optimization techniques.
Avoid Functions in Filters: Using functions in filters can lead to slower query performance because functions often require additional computation and can prevent the database from using indexes efficiently.
Best Practices: It is recommended to simplify filters and avoid complex functions to ensure queries run faster.
Reference: IBM Cognos Analytics V11.1.x documentation suggests avoiding the use of functions in filters as a best practice for improving query performance.
C1000-065 PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 65% Discount on All Products,
Use Coupon: "ac4s65"