Tuning Tips for Database Design

During table design, prefer autogenerated primary keys to user-provided ones. A variation on this is that if an application can assert that the primary key values coming in are already unique, then you can use a normal index over the column tuple and the application does not require a unique index. See CREATE INDEX and Improving Query Performance.