Indexing and query tuning

Indexing and query tuning help you ensure that your database runs its workload efficiently. Missing indexes are a common source of suboptimal performance, and AutoDBA has the algorithms to analyze when adding an index would help, and to distinguish these from indexes that add overhead but do not improve performance.

• Please explain why SELECT ... takes so long to execute. Is there anything I co do to make it faster?
• Are there any missing indexes that would improve the performance of this database?
• I’m thinking about adding a composite index on (user_id, store_id, created_at) for table orders. Would that make any queries run faster? Are there any downsides?
• I want to create an index with the command CREATE INDEX .... Can this operation be done online? How long will it take?
• How many queries run during the past 24 hours have taken more than 15 seconds to execute?