PrepAway - Latest Free Exam Questions & Answers

Which object may be used during query optimization to improve the performance for a subset of SELECT queries?

Which object may be used during query optimization to improve the performance for a subset of
SELECT queries?

PrepAway - Latest Free Exam Questions & Answers

A.
MQT

B.
Trigger

C.
Read Only Cursor

D.
Stored Procedure

One Comment on “Which object may be used during query optimization to improve the performance for a subset of SELECT queries?”

  1. WR says:

    Materialized query tables can significantly improve the performance of queries, especially complex queries. If the optimizer determines that a query or part of a query could be resolved using an MQT, the query might be rewritten to take advantage of the MQT.




    0



    0

Leave a Reply