How to find index column in a table.
Get Information of Index of Tables and Indexed Columns[
^]
How to Get All Indexes List With Involved Columns Name[
^]
What is use of making multiple index.
The optimizer can only use only
one index in a query, so if you create five indexes, the
optimizer will pick the best one to use, and disregard the rest.
If you create one index with five fields, it will use as much of the index as it can. If you restrict on the first field of the index, it will use only that part of the index. If you restrict on the first three fields, it will use all three parts,
resulting in better performance than just having an index on the first field.