How did you implement data indexing in your last project?

In my last project, data indexing was implemented using the built-in capabilities of the database (for example, PostgreSQL). Indexes were created on the most frequently used fields, such as identifiers and timestamps, to speed up searches.

Example of creating an index in SQL:

CREATE INDEX idx_user_id ON orders(user_id);

This significantly sped up data retrieval and filtering without the need for additional processing at the application level.