Is a primary key an index and why?

Yes, in most database management systems, the primary key automatically creates a unique index.

Reasons:

1. Ensuring uniqueness: An index on the primary key allows the DBMS to quickly verify the uniqueness of each new value added to the primary key column. This is critical for maintaining data integrity.
2. Fast search: The primary key is often used to identify specific rows. An index significantly speeds up search operations (WHERE clause) on this column, as the DBMS can quickly find the needed record without scanning the entire table.
3. Join optimization: Indexes on primary keys and corresponding foreign keys optimize table join operations, which are based on these relationships.

Technically, the primary key is a data integrity constraint, and an index is a data structure for fast searching. However, to enforce the uniqueness constraint and ensure search efficiency on the primary key, the DBMS by default creates a unique index.