Query Result Cache?

Whit h two of the following tasks must you perform in order to benefit from the SQL. Query Result
Cache?

Whit h two of the following tasks must you perform in order to benefit from the SQL. Query Result
Cache?

A.
Use a SQL_QUERY_RESULT_CACHEhint in your SQL statement.

B.
Set RESULT_CACHE_MODE to FORCE

C.
Make sure the RESULT_CACHE_MAX_SIZE is greater than 0.

D.
Have SQL statements that are executed repeatedly.

E.
Use temporary tables.

F.
Not use bind variables in your query.

Explanation:



Leave a Reply 0

Your email address will not be published. Required fields are marked *