what approach can a database administrator use to assess the effectiveness of indexes when investigating slow queries?

The approach that a database administrator can  use to assess the effectiveness of indexes when investigating slow queries is option a. Partition large tables.What techniques are used for partitioning huge databases?The Database tables are partitioned using either single-level partitioning or composite partitioning using these information allocation strategies.Note that a partitioned table is a unique table that has been broken into sections, known as partitions, to simplify the management and querying of your data. The efficiency of queries can be enhanced by splitting big tables into smaller partitions, and costs can be managed by limiting the amount of data that must be read by a query. Therefore, In a query in MySQL, PLAIN can be used. It is a fantastic tool that database managers may use to quickly fix sluggish queries by identifying any slow query execution and fixing it as necessary.Learn more about Partition fromhttps://brainly.com/question/456195#SPJ1 See full question belowWhat approach can a database administrator use to assess the effectiveness of indexes when investigating slow queries? a. Partition large tablesb.Change the primary keyc.Run EXPLAIN on queriesd.Inspect query logs