Database design: Which will perform better, auto incremented column or a composite key for appointments
From a purely performance standpoint, using the identity key as a clustered primary key will be most efficient. From there I would do a non clustered key with a unique constraint on datetime, patientid.