Today the interview the interviewer asked me a question, said a table there are 50 field, each field is likely to be as a condition to query, how to tune

CodePudding user response:

Oracle: considering particle grade indexes, if there is a concurrent DML, xie vegetables, pretty run
Save database columns or
Or you can use brute force to run MPP, HADOOP distributed technologies, such as

CodePudding user response:

1, in fact, this problem is given enough information, there is no way to answer, because want to SQL tuning, there must be a lot of information, such as: specific SQL statements, the amount of data table, data distribution and selectivity of each field, etc.
2, about the problem, it is estimated that the interviewer is not an accurate answers, or only a wrong answer,