I how to optimize this table, table how to split things,, every brother please instruct me

CodePudding user response:

400 + field too much, according to the paradigm of open the table, if it is already launched production base, the company no big reconstruction plan, don't go down the table,

Then only control the select field,

CodePudding user response:

The Select query are more fields, each time the query is about half

CodePudding user response:

Half business, if you need to check, the table also has no meaning, even if you tear down or want to check the join,

CodePudding user response:

If the business needs more than the field, so as long as you consider the wide table insert anomalies, delete anomalies, revising the exception if there is no wide table, built the index