How does one determine which index to create to optimize database performance?

The definition of indexes for database optimization is based on analyzing the queries that are executed most frequently and on which fields are used in filtering conditions (WHERE), sorting (ORDER BY), and joins (JOIN). Usually, indexes are created on columns that are frequently involved in searching or linking tables to speed up data access. It is also important to consider that excessive indexes can slow down insert and update operations.