List of usedIndexScan() Examples

Examples of usedIndexScan()

org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedIndexScan()
@param tableName @return true if an Index Scan ResultSet was used for tableName

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedIndexScan()

        expRS = new String[][] { { "1", "2", "2", "2" }, { "2", "4", "4", "4" } };


        JDBC.assertFullResultSet(rs, expRS, true);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected index scan on T3", p.usedIndexScan("T3"));
        assertTrue("Expected index scan on T4", p.usedIndexScan("T4"));


        
        // Can't push predicates into VALUES clauses. Predicate should
        // end up at V2 (T3 and T4).

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedIndexScan()

                { "4", "8", "4", "4" }, { "4", "8", "4", "16" }};


        JDBC.assertFullResultSet(rs, expRS, true);


        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected index scan on T3", p.usedIndexScan("T3"));
        assertTrue("Expected index scan on T4", p.usedIndexScan("T4"));




        // Can't push predicates into VALUES clauses. Optimizer
        // might consider pushing but shouldn't do it; in the end

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedIndexScan()


        JDBC.assertFullResultSet(rs, expRS, true);


        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected index scan on T3", p.usedIndexScan("T3"));
        assertTrue("Expected index scan on T4", p.usedIndexScan("T4"));




        // Can't push predicates into VALUES clauses. Optimizer
        // might consider pushing but shouldn't do it; in the end
        // we'll do a hash join between X1 and T2.

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedIndexScan()

                { "4", "8", "4", "4" }, { "4", "8", "4", "5" },
                { "4", "8", "4", "16" }, { "5", "10", "5", "6" }};
        JDBC.assertFullResultSet(rs, expRS, true);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected table scan on T3", p.usedTableScan("T3"));
        assertTrue("Expected index scan on T4", p.usedIndexScan("T4"));


        
        // Make sure optimizer is still considering predicates for
        // other, non-UNION nodes. Here we should use the
        // predicate to do a hash join between X0 and T5 (i.e. we

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedIndexScan()

        JDBC.assertFullResultSet(rs, expRS, true);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected table scan on T1", p.usedTableScan("T1"));
        assertTrue("Expected table scan on T2", p.usedTableScan("T2"));
        assertTrue("Expected table scan on T3", p.usedTableScan("T3"));
        assertTrue("Expected index scan on T3", p.usedIndexScan("T3"));
        assertTrue("Expected table scan on T4", p.usedTableScan("T4"));
        assertTrue("Expected index scan on T4", p.usedIndexScan("T4"));


        // Here we
        // should see index scans for both instances of T3 and for

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedIndexScan()

        assertTrue("Expected table scan on T1", p.usedTableScan("T1"));
        assertTrue("Expected table scan on T2", p.usedTableScan("T2"));
        assertTrue("Expected table scan on T3", p.usedTableScan("T3"));
        assertTrue("Expected index scan on T3", p.usedIndexScan("T3"));
        assertTrue("Expected table scan on T4", p.usedTableScan("T4"));
        assertTrue("Expected index scan on T4", p.usedIndexScan("T4"));


        // Here we
        // should see index scans for both instances of T3 and for
        // both instances of T4.

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedIndexScan()

            return false;


        RuntimeStatisticsParser rsp =
            new RuntimeStatisticsParser(rStat.getString(1));


        return (rsp.usedIndexRowToBaseRow() && rsp.usedIndexScan()
            && (rsp.rowsQualifiedEquals(expRowCount)));
    }


    /**
     * Helper class: An instance of DataRow represents a single row

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedIndexScan()

        JDBC.assertColumnNames(rs, expColNames);


        expRS = new String[][] { { "9" }};
        JDBC.assertFullResultSet(rs, expRS, true);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected index scan on T3", p.usedIndexScan("T3"));
        assertTrue("Expected index scan on T4", p.usedIndexScan("T4"));




        // Predicates pushed from outer queries shouldn't
        // interfere with inner predicates for subqueries. Mostly

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedIndexScan()


        expRS = new String[][] { { "9" }};
        JDBC.assertFullResultSet(rs, expRS, true);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected index scan on T3", p.usedIndexScan("T3"));
        assertTrue("Expected index scan on T4", p.usedIndexScan("T4"));




        // Predicates pushed from outer queries shouldn't
        // interfere with inner predicates for subqueries. Mostly
        // checking for correct results here.

View Full Code Here

Examples of org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedIndexScan()


        expRS = new String[][] { { "2" }};


        JDBC.assertFullResultSet(rs, expRS, true);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected index scan on T3", p.usedIndexScan("T3"));
        assertTrue("Expected index scan on T4", p.usedIndexScan("T4"));


 
        // Multiple subqueries but NO UNIONs. All predicates are
        // used for joins at their current level (no pushing).

View Full Code Here

0 1 2 3 4 5

TOP

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.