Skip to content
SQLSimplified
BackendQuestion 50 of 52

UUID vs Auto Increment

Problem

The team is debating whether to use auto-incrementing integers or UUIDs for the new users table primary key. You argue for UUIDs because they are essential for distributed systems. Write a query that outputs a column advantage with the value: "UUIDs can be generated by the application independently without database roundtrips."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Loading playground environment...

Hint

Solution