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()

        
        
        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"));


        rs = st
                .executeQuery("select * from (select * from t1 union all select * "
                        + "from t2) x1, (select * from t3 union all select * "
                        + "from t4) x2 where x1.i = x2.a");

View Full Code Here

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

                { "3", "6", "3", "12" }, { "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"));


        
        // Predicate with both sides referencing same UNION isn't a
        // join predicate, so no pushing should happen. So should

View Full Code Here

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

                { "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"));


        
        // Predicate with both sides referencing same UNION isn't a
        // join predicate, so no pushing should happen. So should
        // see regular table scans on all tables.

View Full Code Here

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

                { "4", "-8", "4", "4" }, { "4", "-8", "4", "16" },
                { "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"));




        rs = st
                .executeQuery("select * from (select * from t1 union select * from "

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"));




        rs = st
                .executeQuery("select * from (select * from t1 union select * from "
                        + "t2) x1 (a, b), (select * from t3 union select * "

View Full Code Here

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

                { "4", "-8", "4", "4" }, { "4", "-8", "4", "16" },
                { "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"));


        // In this query the optimizer will consider pushing, but
        // will find that it's cheaper to do a hash join and thus
        // will _not_ push. So we see hash join with table scan on T3.

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"));


        // In this query the optimizer will consider pushing, but
        // will find that it's cheaper to do a hash join and thus
        // will _not_ push. So we see hash join with table scan on T3.

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"));




        // Nested unions with non-join predicates should work as
        // usual (no change with DERBY-805). So should see scalar

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"));




        // Nested unions with non-join predicates should work as
        // usual (no change with DERBY-805). So should see scalar
        // qualifiers on scans for all instances of T1 and T2.

View Full Code Here

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

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.