|
Apache Derby 10.6 | ||||||||
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES |
See:
Description
Interface Summary | |
---|---|
RestrictedVTI | Interface for Table Functions which can be told which columns need to be fetched plus simple bounds on those columns. |
VTICosting | VTICosting is the interface that the query optimizer uses to cost Table Functions. |
VTIEnvironment | VTIEnvironment is the state variable created by the optimizer to help it place a Table Function in the join order. |
Class Summary | |
---|---|
Restriction | An expression to be pushed into a Table Function so that the Table Function can short-circuit its processing and return fewer rows. |
Restriction.AND | An AND of two Restrictions |
Restriction.ColumnQualifier | A simple comparison of a column to a constant value. |
Restriction.OR | An OR of two Restrictions |
Derby lets you declare functions which return ResultSets. You can then use these function results as tables in your queries. This, in turn, lets you do the following:
Here is an example of how to declare and invoke a Table Function:
CREATE FUNCTION externalEmployees () RETURNS TABLE ( employeeId INT, lastName VARCHAR( 50 ), firstName VARCHAR( 50 ), birthday DATE ) LANGUAGE JAVA PARAMETER STYLE DERBY_JDBC_RESULT_SET NO SQL EXTERNAL NAME 'com.acme.hrSchema.EmployeesTable.read' ; INSERT INTO employees SELECT s.* FROM TABLE (externalEmployees() ) s;
The Derby optimizer makes some assumptions about these Table Functions:
Based on these assumptions, the optimizer decides where to place the Table Function in the join order. Using the interfaces in this package, you may override the optimizer's guesses and force the optimizer to choose a better join order.
|
Built on Tue 2010-09-21 16:20:41-0700, from revision 999685 | ||||||||
PREV PACKAGE NEXT PACKAGE | FRAMES NO FRAMES |