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

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


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


        rs = st.executeQuery("select * from V2, V1 where V1.j = V2.b");

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


        rs = st.executeQuery("select * from V2, V1 where V1.j = V2.b");


        expColNames = new String[] { "A", "B", "I", "J" };

View Full Code Here

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


        expRS = new String[][] { { "2", "2", "1", "2" }, { "4", "4", "2", "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"));
      
        // Changes for DERBY-805 don't affect non-join predicates
        // (ex. "IN" or one- sided predicates), but make sure
        // things still behave--i.e. these queries should still

View Full Code Here

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

        expRS = new String[][] { { "2", "2", "1", "2" }, { "4", "4", "2", "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"));
      
        // Changes for DERBY-805 don't affect non-join predicates
        // (ex. "IN" or one- sided predicates), but make sure
        // things still behave--i.e. these queries should still
        // compile and execute without error. We don't expect to

View Full Code Here

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


        expRS = new String[][] { { "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"));
      


        //  Make
        // sure predicates are pushed even if the subquery is

View Full Code Here

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

        expRS = new String[][] { { "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"));
      


        //  Make
        // sure predicates are pushed even if the subquery is
        // explicit (as opposed to a view). Should see index scans

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 case optimizer will consider pushing predicate
        // to X1 but will choose not to because it's cheaper to
        // push the predicate to T3. So should see regular table

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 case optimizer will consider pushing predicate
        // to X1 but will choose not to because it's cheaper to
        // push the predicate to T3. So should see regular table
        // scans on T1 and T2.

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


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

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.