Statistical information collection method and device
The invention provides a statistical information collection method and device. When a data processing completion instruction is received, a table of to-be-collected statistical information is obtained; whether the table of the to-be-collected statistical information meets a preset collection conditi...
Gespeichert in:
Hauptverfasser: | , , , , |
---|---|
Format: | Patent |
Sprache: | chi ; eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | The invention provides a statistical information collection method and device. When a data processing completion instruction is received, a table of to-be-collected statistical information is obtained; whether the table of the to-be-collected statistical information meets a preset collection condition or not is judged; and if yes, the current statistical information of the table of the to-be-collected statistical information is collected according to a preset collection strategy, so that after the data processing is carried out on a table in an Oracle database every time, statistical information in the Oracle database is updated in time. When the data processing completion instruction is received and it is judged that the table of the to-be-collected statistical information meets the preset collection condition, the latest statistical information of the table of the to-be-collected statistical information is collected in time, so that the statistical information adopted for calculatingan SQL execution path by |
---|