A.13.24 OPG_APIS.EXP_EDGE_TAB_STATS
Format
OPG_APIS.EXP_EDGE_TAB_STATS( graph_name IN VARCHAR2, stattab IN VARCHAR2, statid IN VARCHAR2 DEFAULT NULL, cascade IN BOOLEAN DEFAULT TRUE, statown IN VARCHAR2 DEFAULT NULL, stat_category IN VARCHAR2 DEFAULT 'OBJECT_STATS');
Description
Retrieves statistics for the edge table of a given property graph and stores them in the user-created statistics table.
Parameters
- graph_name
-
Name of the property graph.
- stattab
-
Name of the statistics table.
- statid
-
Optional identifier to associate with these statistics within
stattab
. - cascade
-
If
TRUE
, column and index statistics are exported. - statown
-
Schema containing
stattab
. - stat_category
-
Specifies what statistics to export, using a comma to separate values. The supported values are
'OBJECT_STATS'
(the default: table statistics, column statistics, and index statistics) and‘SYNOPSES'
(auxiliary statistics created when statistics are incrementally maintained).
Usage Notes
(None.)
Examples
The following example creates a statistics table, exports into this table the property graph edge table statistics, and issues a query to count the relevant rows for the newly created statistics.
EXECUTE OPG_APIS.CREATE_STAT_TABLE('mystat',null); EXECUTE OPG_APIS.EXP_EDGE_TAB_STATS('mypg', 'mystat', 'edge_stats_id_1', true, null, 'OBJECT_STATS'); SELECT count(1) FROM mystat WHERE statid='EDGE_STATS_ID_1'; 153
Parent topic: OPG_APIS Package Subprograms