Apache Derby 10.9

org.apache.derby.vti
Interface VTICosting


public interface VTICosting

VTICosting is the interface that the query optimizer uses to cost Table Functions. The methods on this interface provide the optimizer with the following information:

The optimizer places a Table Function in the join order after making some assumptions:

The class which contains your Table Function can override these assumptions and improve the join order as follows:

The methods in this interface take a VTIEnvironment argument. This is a state variable created by the optimizer. The methods in this interface can use this state variable to pass information to one another and learn other details of the operating environment.

See Also:
VTIEnvironment

Field Summary
static double defaultEstimatedCost
          A useful constant: The default estimated cost of instantiating and iterating throught a Table Function.
static double defaultEstimatedRowCount
          A useful constant: the default estimated number of rows returned by a Table Function.
 
Method Summary
 double getEstimatedCostPerInstantiation(VTIEnvironment vtiEnvironment)
          Get the estimated cost for a single instantiation of a Table Function.
 double getEstimatedRowCount(VTIEnvironment vtiEnvironment)
          Get the estimated row count for a single scan of a Table Function.
 boolean supportsMultipleInstantiations(VTIEnvironment vtiEnvironment)
          Find out if the ResultSet of the Table Function can be instantiated multiple times.
 

Field Detail

defaultEstimatedRowCount

static final double defaultEstimatedRowCount
A useful constant: the default estimated number of rows returned by a Table Function.

See Also:
Constant Field Values

defaultEstimatedCost

static final double defaultEstimatedCost
A useful constant: The default estimated cost of instantiating and iterating throught a Table Function.

See Also:
Constant Field Values
Method Detail

getEstimatedRowCount

double getEstimatedRowCount(VTIEnvironment vtiEnvironment)
                            throws java.sql.SQLException
Get the estimated row count for a single scan of a Table Function.

Parameters:
vtiEnvironment - The state variable for optimizing the Table Function.
Returns:
The estimated row count for a single scan of the Table Function.
Throws:
java.sql.SQLException - thrown if the costing fails.

getEstimatedCostPerInstantiation

double getEstimatedCostPerInstantiation(VTIEnvironment vtiEnvironment)
                                        throws java.sql.SQLException
Get the estimated cost for a single instantiation of a Table Function.

Parameters:
vtiEnvironment - The state variable for optimizing the Table Function.
Returns:
The estimated cost for a single instantiation of the Table Function.
Throws:
java.sql.SQLException - thrown if the costing fails.

supportsMultipleInstantiations

boolean supportsMultipleInstantiations(VTIEnvironment vtiEnvironment)
                                       throws java.sql.SQLException
Find out if the ResultSet of the Table Function can be instantiated multiple times.

Parameters:
vtiEnvironment - The state variable for optimizing the Table Function.
Returns:
True if the ResultSet can be instantiated multiple times, false if can only be instantiated once.
Throws:
java.sql.SQLException - thrown if the costing fails.

Built on Thu 2012-05-31 12:19:36-0700, from revision 1344872

Apache Derby 10.9 API Documentation - Copyright © 2004,2012 The Apache Software Foundation. All Rights Reserved.