oracle.pg.rdbms

Interface OracleStats

public interface OracleStats

This interface defines statistics related APIs that are supported by OraclePropertyGraph

Method Summary

Modifier and Type	Method and Description
void	analyze(float estimatePercent, java.lang.String methodOpt) Collects statistics for this graph.
void	analyze(float estimatePercent, java.lang.String methodOpt, int dop) Collects statistics for this graph.
void	analyze(int dop) Collects statistics for this graph.
void	createStatTable(java.lang.String statTableName) This method creates a stat table using DBMS_STATS package.
void	expEdgeStat(java.lang.String statTableName, java.lang.String statid) This method exports the edge table statistics into the given stat table.
void	expVertexStat(java.lang.String statTableName, java.lang.String statid) This method exports the vertex table statistics into the given stat table.
void	impEdgeStat(java.lang.String statTableName, java.lang.String statid) This method imports the edge table statistics from the given stat table.
void	impVertexStat(java.lang.String statTableName, java.lang.String statid) This method imports the vertex table statistics from the given stat table.

Method Detail

analyze

void analyze(float estimatePercent,
             java.lang.String methodOpt)
      throws java.sql.SQLException

Collects statistics for this graph. Behind the scenes, Oracle database will invoke DBMS_STATS package and collect statistics for the underlying vertex and edge tables of this graph.

It is very important that up-to-date statistics be maintained for a graph to ensure efficient execution of query and inference. The SQL Optimizer needs accurate information to choose a good execution plan.

After a significant amount of change has been done to a graph, this method should be invoked. Notice that however, statistics collection is a time/resource consuming process, so only run it when necessary.

See Oracle documentation "PL/SQL Packages and Types Reference" for detailed explanations of the parameters.

Parameters:

estimatePercent - has a valid range of [0.000001,100].

methodOpt - A typical value for methodOpt is "FOR ALL COLUMNS SIZE AUTO"

Throws:

java.sql.SQLException - when there is error generated from DBMS_STATS package.

analyze

void analyze(float estimatePercent,
             java.lang.String methodOpt,
             int dop)
      throws java.sql.SQLException

Collects statistics for this graph. Behind the scenes, Oracle database will invoke DBMS_STATS package and collect statistics for the underlying vertex and edge tables of this graph.

It is very important that up-to-date statistics be maintained for a graph to ensure efficient execution of query and inference. The SQL Optimizer needs accurate information to choose a good execution plan.

After a significant amount of change has been done to a graph, this method should be invoked. Notice that however, statistics collection is a time/resource consuming process, so only run it when necessary.

See Oracle documentation "PL/SQL Packages and Types Reference" for detailed explanations of the parameters.

Parameters:

estimatePercent - has a valid range of [0.000001,100].

methodOpt - A typical value for methodOpt is "FOR ALL COLUMNS SIZE AUTO"

dop - degree of parallelism.

Throws:

java.sql.SQLException - when there is error generated from DBMS_STATS package.

analyze

void analyze(int dop)
      throws java.sql.SQLException

Collects statistics for this graph. Behind the scenes, Oracle database will invoke DBMS_STATS package and collect statistics for the underlying vertex and edge tables of this graph.

It is very important that up-to-date statistics be maintained for a graph to ensure efficient execution of query and inference. The SQL Optimizer needs accurate information to choose a good execution plan.

After a significant amount of change has been done to a graph, this method should be invoked. Notice that however, statistics collection is a time/resource consuming process, so only run it when necessary.

See Oracle documentation "PL/SQL Packages and Types Reference" for detailed explanations of the parameters.

Parameters:

dop - degree of parallelism.

Throws:

java.sql.SQLException - when there is error generated from DBMS_STATS package.

createStatTable

void createStatTable(java.lang.String statTableName)
              throws java.sql.SQLException

This method creates a stat table using DBMS_STATS package.

Parameters:

statTableName - name of the stat table.

Throws:

java.sql.SQLException - when there is error generated from DBMS_STATS package.

expEdgeStat

void expEdgeStat(java.lang.String statTableName,
                 java.lang.String statid)
          throws java.sql.SQLException

This method exports the edge table statistics into the given stat table.

Parameters:

statTableName - name of the stat table.

statid - identifier of statistics

Throws:

java.sql.SQLException - when there is error generated from DBMS_STATS package.

expVertexStat

void expVertexStat(java.lang.String statTableName,
                   java.lang.String statid)
            throws java.sql.SQLException

This method exports the vertex table statistics into the given stat table.

Parameters:

statTableName - name of the stat table.

statid - identifier of statistics

Throws:

java.sql.SQLException - when there is error generated from DBMS_STATS package.

impEdgeStat

void impEdgeStat(java.lang.String statTableName,
                 java.lang.String statid)
          throws java.sql.SQLException

This method imports the edge table statistics from the given stat table.

Parameters:

statTableName - name of the stat table.

statid - identifier of statistics

Throws:

java.sql.SQLException - when there is error generated from DBMS_STATS package.

impVertexStat

void impVertexStat(java.lang.String statTableName,
                   java.lang.String statid)
            throws java.sql.SQLException

This method imports the vertex table statistics from the given stat table.

Parameters:

statTableName - name of the stat table.

statid - identifier of statistics

Throws:

java.sql.SQLException - when there is error generated from DBMS_STATS package.