A clustered index determines the physical order of data in a database table, making it efficient for retrieving rows based on indexed columns. It is typically created on the primary key, and there can only be one clustered index per table because the data rows themselves are stored in the order of the index.