PrepAway - Latest Free Exam Questions & Answers

What happens?

Alternate index access is chosen by the optimizer. The index is not available at runtime. What
happens?

PrepAway - Latest Free Exam Questions & Answers

A.
The query executes successfully because the query execution plan (QEP) is available.

B.
Automatic recompilation is launched.

C.
Query execution fails.

D.
AUTORECOMPILE fails if SIMILARITYCHECK is not enabled.


Leave a Reply