Is it possible to create a composite index on multiple columns in a database?

Yes, most modern database management systems (DBMS) support the creation of composite (compound) indexes on multiple columns. Such an index can speed up queries that filter or sort data based on several fields simultaneously.

Example of creating a composite index in SQL:

CREATE INDEX idx_name ON table_name (column1, column2);

It is important to remember that the order of columns in a composite index affects its efficiency. The index will be most effective for queries where filtering or sorting starts with the first column of the index.