hello,

i have 2 tables

Table1
74 fields
Total size of one row: 4302 bytes

Table2
65 fields
Total size one row: 4786 bytes

theses tables are link by a 1=1 relation. around 10 000 000 rows in each table

Is their any advantage to keep the data in 2 tables instead of one ?
i can eventually reduce the size on the row to make that it's can fit inside a page of the database (8192)

but it's a huge job to do, so before to start it prefere just to have your opinion ...