I need to create a table to store the fields "Name" (VarChar2 100 characters), "CPF" (VarChar2, 11 characters), and "Birth" (Date).
The "CPF" is required and unique (exclusive), has manual input that is fed by the user.
What I have tried:
I can create this table using the "CPF" field as the primary key, or can create another numeric field type (eg "id") with automatic entry using triggers to serve as the primary key.
My questions are as follows:
1 - Which of the two ways will perform better?
2. - Considering performance and consumption, which of the two forms would you recommend?
Thank you for your attention.