Billions of data
Field is A and B
Is the content of B's phone number
Want to pass the query B cell phone number for query output

Excuse me,
1. The circumstances which index index should use MYSQL?
2. Billions of data to a table had better put how many rows of data?
Data is specified billions of because it is the company of the backup data fetched up do history query,
Give him how much fixed after data import, late will give them another new table

CodePudding user response:

Suggest a table, beginning a 130, 131 at the beginning of a, and so on,

If not yet, 2, 1300130, 1130 such table,

CodePudding user response:

According to the mobile phone number mantissa building table from 0 to 9

CodePudding user response:

According to the mobile phone number to build index, table, table manner in accordance with the above them roughly or other forms can be custom

CodePudding user response:

Billions of data don't use the mysql, if only for a query solution has a lot of

CodePudding user response:

This case can use es such as solution,