In which cases is it recommended to use indexes in a database?

Indexes in a database are recommended to be used in the following cases:

• To speed up search and data retrieval on columns frequently used in queries (for example, keys, foreign keys, filtering fields).
• When there is a need for quick sorting and grouping operations on certain fields.
• To ensure the uniqueness of values in columns (unique indexes).

However, indexes occupy additional space and slow down insert, update, and delete operations, so they should be used consciously.

Example: if queries of the type

SELECT * FROM users WHERE email = 'example@example.com';

are frequently performed, it is advisable to create an index on the email column to speed up search.