Examples of org.apache.derby.vti.VTICosting

org.apache.derby.vti.VTICosting
VTICosting is the interface that the query optimizer uses to cost VTIs. The methods on the interface provide the optimizer with the following information:
- the estimated number of rows returned by the VTI in a single instantiation.
- the estimated cost to instantiate and iterate through the VTI.
- whether or not the VTI can be instantiated multiple times within a single query execution
This class can only be used within an SQL-J statement. Using the methods in application-side Java code results in Exceptions being thrown. @see org.apache.derby.vti.VTIEnvironment

     */
    if (implementsVTICosting && ! vtiCosted)
    {
      try
      {
        VTICosting vtic = (version2) ? (VTICosting) ps : (VTICosting) rs;
        estimatedCost = vtic.getEstimatedCostPerInstantiation(this);
        estimatedRowCount = vtic.getEstimatedRowCount(this);
        supportsMultipleInstantiations = vtic.supportsMultipleInstantiations(this);


        if (ps != null) {
          ps.close();
          ps = null;
        }

View Full Code Here

     */
    if (implementsVTICosting && ! vtiCosted)
    {
      try
      {
        VTICosting vtic = (version2) ? (VTICosting) ps : (VTICosting) rs;
        estimatedCost = vtic.getEstimatedCostPerInstantiation(this);
        estimatedRowCount = vtic.getEstimatedRowCount(this);
        supportsMultipleInstantiations = vtic.supportsMultipleInstantiations(this);


        if (ps != null) {
          ps.close();
          ps = null;
        }

View Full Code Here

     */
    if (implementsVTICosting && ! vtiCosted)
    {
      try
      {
        VTICosting vtic = (version2) ? (VTICosting) ps : (VTICosting) rs;
        estimatedCost = vtic.getEstimatedCostPerInstantiation(this);
        estimatedRowCount = vtic.getEstimatedRowCount(this);
        supportsMultipleInstantiations = vtic.supportsMultipleInstantiations(this);


        if (ps != null) {
          ps.close();
          ps = null;
        }

View Full Code Here

     */
    if (implementsVTICosting && ! vtiCosted)
    {
      try
      {
        VTICosting vtic = getVTICosting();
        estimatedCost = vtic.getEstimatedCostPerInstantiation(this);
        estimatedRowCount = vtic.getEstimatedRowCount(this);
        supportsMultipleInstantiations = vtic.supportsMultipleInstantiations(this);


        if (ps != null) {
          ps.close();
          ps = null;
        }

View Full Code Here

        String              className = methodCall.getJavaClassName();
        Class               vtiClass = lookupClass( className );
        
        try {
            Constructor         constructor = vtiClass.getConstructor( new Class[] {} );
            VTICosting          result = (VTICosting) constructor.newInstance( null );


            return result;
        }
        catch (Throwable t)
        {

View Full Code Here

     */
    if (implementsVTICosting && ! vtiCosted)
    {
      try
      {
        VTICosting vtic = (version2) ? (VTICosting) ps : (VTICosting) rs;
        estimatedCost = vtic.getEstimatedCostPerInstantiation(this);
        estimatedRowCount = vtic.getEstimatedRowCount(this);
        supportsMultipleInstantiations = vtic.supportsMultipleInstantiations(this);


        if (ps != null) {
          ps.close();
          ps = null;
        }

View Full Code Here

     */
    if (implementsVTICosting && ! vtiCosted)
    {
      try
      {
        VTICosting vtic = getVTICosting();
        estimatedCost = vtic.getEstimatedCostPerInstantiation(this);
        estimatedRowCount = vtic.getEstimatedRowCount(this);
        supportsMultipleInstantiations = vtic.supportsMultipleInstantiations(this);


        if (ps != null) {
          ps.close();
          ps = null;
        }

View Full Code Here

        String              className = methodCall.getJavaClassName();
        Class               vtiClass = lookupClass( className );
        
        try {
            Constructor         constructor = vtiClass.getConstructor( new Class[] {} );
            VTICosting          result = (VTICosting) constructor.newInstance( null );


            return result;
        }
        catch (Throwable t)
        {

View Full Code Here

     */
    if (implementsVTICosting && ! vtiCosted)
    {
      try
      {
        VTICosting vtic = getVTICosting();
        estimatedCost = vtic.getEstimatedCostPerInstantiation(this);
        estimatedRowCount = vtic.getEstimatedRowCount(this);
        supportsMultipleInstantiations = vtic.supportsMultipleInstantiations(this);


        if (ps != null) {
          ps.close();
          ps = null;
        }

View Full Code Here

        Class<?>               vtiClass = lookupClass( className );
        
        try {
            Constructor<?> constructor =
                    vtiClass.getConstructor( new Class<?>[] {} );
            VTICosting          result =
                    (VTICosting) constructor.newInstance( (Object[])null );


            return result;
        }
        catch (Throwable t)

View Full Code Here

0 1 2

TOP

Related Classes of org.apache.derby.vti.VTICosting

org.apache.derby.impl.sql.compile.FromVTI

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.