Categories
database database-design mysql oracle postgresql

Table with a lot of attributes

I’m planing to build some database project.

One of the tables have a lot of attributes.

My question is: What is better, to divide the the class into 2 separate tables or put all of them into one table. below is an example

create table User { id, name, surname,... show_name, show_photos, ...)

or

create table User { id, name, surname,... )
create table UserPrivacy {usr_id, show_name, show_photos, ...)

The performance i suppose is similar due to i can use index.