In what situations is it recommended to create indexes in a database?

Indexes in a database are recommended to be created in the following situations:

• To speed up searches and queries on columns frequently used in WHERE, JOIN, or ORDER BY clauses.
• When the table contains a large number of records, and queries become slow without an index.
• To ensure the uniqueness of values in columns (unique indexes).
• When performing sorting or grouping operations on certain fields frequently.

However, indexes occupy additional space and slow down insert, update, and delete operations, so they should be created consciously, based on actual data usage scenarios.