Sesame oil, I'd like to have a data in the database according to the value of a column to different index table, don't know this function can be fulfilled?
To find the document and all kinds of materials, didn't introduce the function, please give directions,
Thank you very much

CodePudding user response:

The index table is what

CodePudding user response:

Isn't it will be a large table into multiple small table

CodePudding user response:

reference 1st floor AHUA1001 response:

index table is what

I'm sorry, expression may have a problem,
I mean in a base table indexed, but this index contains only a part of the line, multiple index containing data to cover the entire basic data in a table

CodePudding user response:

Index of value, is to improve the efficiency of the query, there are some fields, there is no need to add to the index,
Such as table has the following fields: the primary key, name, gender, date of birth, politics, education, marital status, remarks,
This table primary key is not to need to build indexes, and direct the query note, also it is almost impossible, so note also do not need to set up index,
In addition, if every time the query, will use the name, so other several columns, there would be no need to create an index,
According to the thinking of you said, each field, can be separately set up an index, but it can affect the INSERT, DELETE, UPDATE efficiency,