Should I split a single table with an AUTO_INCREMENT PRIMARY KEY into two tables that can be joined on that PRIMARY KEY? I have a table that has 46 fields with an AUTO_INCREMENT PRIMARY KEY.  It's hard to look at a table that has this many columns, so I frequently use a SELECT statement to look at 34 of the fields that I mentally categorize as 'group 1' and 12 fields that I categorize as 'group 2'.

Would I face a performance hit on reads/writes if I split this table into two tables, one with 34 fields and another with 12 fields.

Both would have the same AUTO_INCREMENT PRIMARY KEY so that they could be joined on the PRIMARY key if I need to look at at 46 fields at once.
It's hard to look at a table that has this many columns, so I
  frequently use a SELECT statement to look at 34 of the fields that I
  mentally categorize as 'group 1' and 12 fields that I categorize as
  'group 2'.


Create a view.