Statistical information collection method and device

A statistical information and collection device technology, applied in the field of database statistical information collection, can solve problems such as affecting the efficiency of SQL execution

Inactive Publication Date: 2018-11-16
BANK OF CHINA
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, when the statistical information of SQL-related objects expires outside the specified time period, the CBO in the Oracle database still uses the statistical information collected within the specified time period for path calculation, resulting in the calculated SQL execution path not being the lowest. The path of cost seriously affects the execution efficiency of SQL

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Statistical information collection method and device
  • Statistical information collection method and device
  • Statistical information collection method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0098] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0099] The embodiment of the present invention discloses a method for collecting statistical information, please refer to the attached figure 1 , the method specifically includes the following steps:

[0100] S101: Obtain a table of statistical information to be collected when receiving a data processing completion instruction;

[0101] Specifically, the data processing completion instruction means that the currently used application system has performed data...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

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 CBO can be ensured to be the latest statistical information all the time, the calculated SQL execution path is ensured to be an optimal path, and the SQL execution efficiencyis improved.

Description

technical field [0001] The present invention relates to the field of database statistical information collection, and more specifically, relates to a method and device for collecting statistical information. Background technique [0002] In the Oracle database, statistical information refers to the information used to describe the physical characteristics of SQL-related objects in the Oracle database: tables and indexes, such as the number of rows in the table, the disk space occupied by the table, and the number of rows in the index. The CBO (Cost Based Optimizer) in the Oracle database can calculate the cost of different SQL execution paths based on the currently collected statistical information, and then select a path with the lowest cost as the SQL execution plan. It can be seen that the accuracy of statistical information in the Oracle database has a significant impact on the SQL execution path with the least cost calculated by CBO. [0003] At present, the commonly u...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & AuthorityApplications(China)
IPC IPC(8): G06F17/30
Inventor裴炜裕易金华黄志鸿雷立动廖旺胜
OwnerBANK OF CHINA