Has a start time and end time (optimization)

CodePudding user response:

If it is I received data needs to look up for a period of time, amount of data for hundreds of millions of article, I'll check first asked why the demand for such data, because the demand is not very reasonable, what it means to look up so much of the data, is to be exported to do analysis? The analysis of SQL to you can do?
If there is to check, the data can be narrowed down?
Can't narrowed down, look for a person to discuss or consulting experience in this aspect of personnel consulting do more appropriate (fear that this query will cause a server down)

CodePudding user response:

?? He is to want to take an examination of how to optimize your data query question

CodePudding user response:

Yes, that is, ask the direction! But do not know how to solve

CodePudding user response:

Large amounts of data query exam you nothing but the use of partition tables and indexes

CodePudding user response:

For oracle, a large number of queries, consider the partition 2, three consider data compression, establish the reasonable index,