Question $3$

$0\mathrm{.}15$ pts

Mark is responsible for maintaining the performance of a large e$-$commerce database. He needs to ensure that indexes are used effectively to speed up query performance. What strategies should Mark employ to optimize the use of indexes? Select TWO.

Create composite indexes on columns used together in queries.

Monitor index usage statistics and remove unused indexes.

Create indexes on columns frequently used in WHERE chases.

Regularly rebuild and reorganize indexes.

Use only primary key indexes to maintain simplicity.