Data in the table have ABC four fields represent different meanings, assume that A, B, C field has n different values, the number of values is not solid, there will be A repeat, D field has m different values, m value is fixed D1, D2, D3, table data in about 100 w, assuming that in case of need real-time statistics, how to use SQL to generate real-time statistics results under oracle, providing ideas

CodePudding user response:

Use materialized views try:
https://www.cnblogs.com/jianshuai520/p/10246136.html

CodePudding user response:

This depends on what data you need?
Is too abstract, can't give you,

CodePudding user response:

Data source table 100 w much ah, can also get real-time combining your cpus, the memory configuration, etc., the resulting result set is large or small,

Can consider to add parallel, make full use of CPU resources quickly find out the result,