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[][] { { "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

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

        expColNames = new String[] { "A", "I" };
        JDBC.assertColumnNames(rs, expColNames);
        JDBC.assertDrainResults(rs, 0);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected hash join", p.usedHashJoin());
        assertTrue("Expected index scan on T3", p.usedIndexScan("T3"));
        assertTrue("Expected index scan on T4", p.usedIndexScan("T4"));


        // Same as
        // above but without the inner predicate (so no hash on T6).

View Full Code Here

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

        JDBC.assertColumnNames(rs, expColNames);
        JDBC.assertDrainResults(rs, 0);
        p = SQLUtilities.getRuntimeStatisticsParser(st);
        assertTrue("Expected hash join", p.usedHashJoin());
        assertTrue("Expected index scan on T3", p.usedIndexScan("T3"));
        assertTrue("Expected index scan on T4", p.usedIndexScan("T4"));


        // Same as
        // above but without the inner predicate (so no hash on T6).


        rs = st

View Full Code Here

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


    


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


        // Same as above, but without the outer predicate. Should
        // see table scan on T3 and T4 (because nothing is pushed).

View Full Code Here

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

    


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


        // Same as above, but without the outer predicate. Should
        // see table scan on T3 and T4 (because nothing is pushed).


        rs = st

View Full Code Here

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

        }
        
        s.executeQuery("SELECT * FROM " + whiteSpace + DERBY_6045_DATA_TABLE + 
            " WHERE TERM_ID = 11");
        rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
        assertTrue(rtsp.usedIndexScan());


        s.executeQuery("SELECT  *  FROM  " + whiteSpace + DERBY_6045_DATA_TABLE + 
            " WHERE (TERM_ID = 11) OR " +
            "(TERM_ID =21) OR (TERM_ID = 31)");
        rtsp = SQLUtilities.getRuntimeStatisticsParser(s);

View Full Code Here

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


        s.executeQuery("SELECT  *  FROM  " + whiteSpace + DERBY_6045_DATA_TABLE + 
            " WHERE (TERM_ID = 11) OR " +
            "(TERM_ID =21) OR (TERM_ID = 31)");
        rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
        assertTrue(rtsp.usedIndexScan());


        s.executeQuery("SELECT  *  FROM " + whiteSpace + DERBY_6045_DATA_TABLE 
            + " WHERE (TERM_ID IN (11, 21, 31))");
        rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
        assertTrue(rtsp.usedIndexScan());

View Full Code Here

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

        assertTrue(rtsp.usedIndexScan());


        s.executeQuery("SELECT  *  FROM " + whiteSpace + DERBY_6045_DATA_TABLE 
            + " WHERE (TERM_ID IN (11, 21, 31))");
        rtsp = SQLUtilities.getRuntimeStatisticsParser(s);
        assertTrue(rtsp.usedIndexScan());
    }


    public void testDerby3603()
        throws SQLException
    {

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

            rs.close();
            if (expectedScan.equals("Table"))
                    assertTrue(rtsp.usedTableScan());
            else if (expectedScan.equals("Index"))
            {
                assertTrue(rtsp.usedIndexScan());
                assertTrue(rtsp.usedSpecificIndexForIndexScan(
                        expTableInIndexScan, expIndexInIndexScan));
            }
            else if (expectedScan.equals("Constraint"))
            {

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.