Scene description:
1, the history data record table according to day
2, each grouped table with key field partition (hash partitioning) each table is set 10 partitions each partition of the data about 10 million or so for the

Requirements:
1, what are the statistics on the day of the primary key from the table (not the only index) on record, access to the primary key to heavy after
2, according to go to the primary key from the day after the heavy table to get the primary key of the maximum value of a numeric field under, the minimum

Other requirements:
1, performance requirements, efficient as possible

CodePudding user response:

1, from the table, what are the statistics on the day of the primary key (not the only index) on record, access to the primary key to heavy after


The primary key, how can not only the index?

CodePudding user response:

reference 1st floor wmxcn2000 response:

1, from the table, what are the statistics on the day of the primary key (not the only index) on record, access to the primary key to heavy after


The primary key, how can not only the index?

Wrong just a few key words of a standard index the index values as the key value of the structure of eventual reunification

CodePudding user response:

The building Lord what you mean to ask questions or think outsourcing,,,,
You do what you want, write a oracle big title data?
Use oracle to calculate or use big data to calculate

CodePudding user response:

To delete the repeated operation, or a query repeated operations

CodePudding user response:

The original poster with group by directly and set function is no good performance??

CodePudding user response:

Issue seems to be not describe clearly!