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? (Choose two.)
Date should be a TIMESTAMP field for better performance.
The User field is too long for most names.
The engine type is not appropriate to the application use.
Using default values for DATETIME causes table scans.
No indexes are defined.
Submit