1Z0-888 Exam Dumps | After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries

<< Prev Question Next Question >>

After analysis on the slow query log on a high-end OLTP service, the table identified in the slow queries is:

What are the two most likely reasons for the slowness given this output?

A. The engine type is not appropriate to the application use.

B. Dateshould be a TIMESTAMPfield for better performance.

C. No indexes are defined.

D. Using default values for DATETIMEcauses table scans.

E. The User field is too long for most names.

Download PDF File