Indexes

A Primary Index is an automatic, unique index created on a table's primary key for fast data retrieval. It ensures quick lookups, enforces uniqueness, and boosts performance in relational databases.

A Composite Index combines two or more columns into a single index to speed up queries filtering or sorting by multiple fields. Column order matters, and the index supports queries starting with the leftmost column(s).

A Unique Index enforces distinct values in a column, preventing duplicates while speeding up queries. It's ideal for fields like email or username, ensuring data accuracy with minimal impact on read performance.