Which component is used to optimize the performance of views by hinting at query execution details?

• A. Object Type
• B. Query Hint
• C. Batch Set
• D. Viewer

Answer: (B)

Query hints let you influence how a query is executed to improve performance when loading views. By applying a hint, you guide the query engine on details like which index to use or how to structure the execution plan, helping the system fetch results more efficiently and render the view faster, especially with large datasets. Other components have different roles: Object Type defines what kinds of objects are included, Batch Set groups operations for processing, and Viewer controls how results are presented. They don’t steer the query execution in the same targeted way. So, the tool used to optimize performance by hinting at query execution details is the query hint.