List of usedLastKeyIndexScan() Examples

Examples of usedLastKeyIndexScan()

org.apache.derbyTesting.junit.RuntimeStatisticsParser.usedLastKeyIndexScan()
Return whether or not a last key index scan result set was used in the query. A last key index scan is a special optimization for MIN and MAX queries against an indexed column (SELECT MAX(ID) FROM T).

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

        JDBC.assertFullResultSet(
                s.executeQuery("SELECT MAX(D1) FROM D3904_T1"),
            new String[][] {  {"2008-10-02"} } );
    RuntimeStatisticsParser rtsp =
      SQLUtilities.getRuntimeStatisticsParser(s);
    assertTrue(rtsp.usedLastKeyIndexScan());
    assertFalse(rtsp.usedIndexRowToBaseRow());


    // A form of the Beetle 4423 query:
        JDBC.assertFullResultSet(
                s.executeQuery("SELECT MAX(D1) " +

View Full Code Here

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

        JDBC.assertFullResultSet(
                s.executeQuery("SELECT MAX(D1) FROM D3904_T1"),
            new String[][] {  {"2008-10-02"} } );
    RuntimeStatisticsParser rtsp =
      SQLUtilities.getRuntimeStatisticsParser(s);
    assertTrue(rtsp.usedLastKeyIndexScan());
    assertFalse(rtsp.usedIndexRowToBaseRow());


    // A form of the Beetle 4423 query:
        JDBC.assertFullResultSet(
                s.executeQuery("SELECT MAX(D1) " +

View Full Code Here

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

        JDBC.assertFullResultSet(
                s.executeQuery("SELECT MAX(D1) FROM D3904_T1"),
            new String[][] {  {"2008-10-02"} } );
    RuntimeStatisticsParser rtsp =
      SQLUtilities.getRuntimeStatisticsParser(s);
    assertTrue(rtsp.usedLastKeyIndexScan());
    assertFalse(rtsp.usedIndexRowToBaseRow());


    // A form of the Beetle 4423 query:
        JDBC.assertFullResultSet(
                s.executeQuery("SELECT MAX(D1) " +

View Full Code Here

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

        JDBC.assertFullResultSet(
                s.executeQuery("SELECT MAX(D1) FROM D3904_T1"),
            new String[][] {  {"2008-10-02"} } );
    RuntimeStatisticsParser rtsp =
      SQLUtilities.getRuntimeStatisticsParser(s);
    assertTrue(rtsp.usedLastKeyIndexScan());
    assertFalse(rtsp.usedIndexRowToBaseRow());


    // A form of the Beetle 4423 query:
        JDBC.assertFullResultSet(
                s.executeQuery("SELECT MAX(D1) " +

View Full Code Here

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

        JDBC.assertFullResultSet(
                s.executeQuery("SELECT MAX(D1) FROM D3904_T1"),
            new String[][] {  {"2008-10-02"} } );
    RuntimeStatisticsParser rtsp =
      SQLUtilities.getRuntimeStatisticsParser(s);
    assertTrue(rtsp.usedLastKeyIndexScan());
    assertFalse(rtsp.usedIndexRowToBaseRow());


    // A form of the Beetle 4423 query:
        JDBC.assertFullResultSet(
                s.executeQuery("SELECT MAX(D1) " +

View Full Code Here

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

        JDBC.assertFullResultSet(
                s.executeQuery("SELECT MAX(D1) FROM D3904_T1"),
            new String[][] {  {"2008-10-02"} } );
    RuntimeStatisticsParser rtsp =
      SQLUtilities.getRuntimeStatisticsParser(s);
    assertTrue(rtsp.usedLastKeyIndexScan());
    assertFalse(rtsp.usedIndexRowToBaseRow());


    // A form of the Beetle 4423 query:
        JDBC.assertFullResultSet(
                s.executeQuery("SELECT MAX(D1) " +

View Full Code Here

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.