I currently have a table with 50 columns
It has 100 millions rows
I could reorganise these to approx 20 as not all the columns are used for each row
I would need to create a new table for the other data
Is it generally a good idea to try and get each row under 8kb?
I've been reading a lot into performance tuning and optimization recently so wondering if I need to get the foundation right