PrepAway - Latest Free Exam Questions & Answers

Which information is part of the DSN_STATEMENT_CACHE_TABLE?

The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which
information is part of the DSN_STATEMENT_CACHE_TABLE?

PrepAway - Latest Free Exam Questions & Answers

A.
Filter factor information.

B.
Stage 1 and stage 2 information.

C.
Number of columns used in an index.

D.
Number of times an SQL statement is executed.

Explanation:


Leave a Reply