Home > database >  Oracle database to screen time. The amount of the data and then do some fields of hundreds of thousa
Oracle database to screen time. The amount of the data and then do some fields of hundreds of thousa

Time:10-01

As title, to do statistical analysis, don't know the amount of data about how long it takes?

CodePudding user response:

Data volume is not big, again not
But specific still should see you of the machine configuration, the allocation of resources, the current space, the memory of, etc., need to take into account the factors more

CodePudding user response:

reference 1st floor js14982 response:
data volume is small, can't
But specific still should see you of the machine configuration, the allocation of resources, the current space, the memory of, etc., need to take into account the factors more

May express is wrong, should be out there are hundreds of thousands of data rather than from the hundreds of thousands of sifting through the data, this article hundreds of thousands of is a month of data, the total amount of data is at least millions of article

CodePudding user response:

The main problem is to consider and allow the user to use statistical function real-time computing, the user experience is not good, if can be time consuming to use plan task into data, when user query is take the good result set

CodePudding user response:

Statements do execution plan, can see this is carried out for how long, is there can be optimized,
  • Related