Overview Indexes are a powerful concept in any RDBMS. They can dramatically increase the performance of queries, but they can…