What are the differences between UUID, auto-incrementing integer, and other primary key strategies? What are the trade-offs for each?

Sample answer preview

The choice of primary key strategy affects database performance, application design, security, and scalability. Each approach has meaningful trade-offs that a DBA should understand to make informed recommendations.