Which of the following is true about the Database Engine Tuning Advisor?

A. the administrator must have detailed knowledge of the database schema to use it
B. performance gains of less than 25% should be discounted
C. it quantifies the expected performance gains for each recommendation
D. it uses a different set of data than the query optimizer

Answer: C

Computer Science & Information Technology

You might also like to view...

What is the broadening of a pulse due to the different propagation of the spectral components of the light pulse called?

A) Modal dispersion B) Diffusion C) Chromatic dispersion D) Polarization mode dispersion

Computer Science & Information Technology

Curly braces are not required in the body of a while loop if only one statement is being repetitively executed.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology