Hi, 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.