A list in Oracle, the amount of data is too great in any way? When under table need to consider

CodePudding user response:

This want to combine the actual business, not simple,

CodePudding user response:

Primary keys, indexes, data volume is too big, can create the history table

CodePudding user response:

Can try partition

CodePudding user response:

The first thing to consider two questions, you take this form to do (how to gain authorization query?) , how are you going to manage this table data? (how to deal with historical data, etc.)

CodePudding user response:

Is often built for history table, partition table, such as some concept of time is stronger, such as securities water is day by day, so the average monthly partitions, built after the partition table, must be clear on the difference between the index of the local and global index

CodePudding user response:

1, to say clear your business scenario
2, what kind of scale is too big