Package org.apache.derby.impl.sql.catalog

Examples of org.apache.derby.impl.sql.catalog.XPLAINSortPropsDescriptor

1954
1955
1956
1957
1958
1959
1960
1961
1962
        createXplainTable(lcc, schemaName,
                new XPLAINResultSetTimingsDescriptor());
        createXplainTable(lcc, schemaName,
                new XPLAINScanPropsDescriptor());
        createXplainTable(lcc, schemaName,
                new XPLAINSortPropsDescriptor());
        lcc.setRunTimeStatisticsMode(statsSave);
        lcc.setXplainSchema(schemaName);
    }
View Full Code Here
1958
1959
1960
1961
1962
1963
1964
1965
1966
        createXplainTable(lcc, schemaName,
                new XPLAINResultSetTimingsDescriptor());
        createXplainTable(lcc, schemaName,
                new XPLAINScanPropsDescriptor());
        createXplainTable(lcc, schemaName,
                new XPLAINSortPropsDescriptor());
        lcc.setRunTimeStatisticsMode(statsSave);
        lcc.setXplainSchema(schemaName);
    }
View Full Code Here
435
436
437
438
439
440
441
442
443
444
445
446
447
        ps = conn.prepareStatement(
            (String)lcc.getXplainStatement("SYSXPLAIN_SORT_PROPS"));
        iter = sortrsets.iterator();
        while (iter.hasNext())
        {
            XPLAINSortPropsDescriptor sortProps =
                (XPLAINSortPropsDescriptor)iter.next();
            sortProps.setStatementParameters(ps);
            ps.executeUpdate();
        }
        ps.close();

        conn.close();
View Full Code Here
2084
2085
2086
2087
2088
2089
2090
2091
2092
        createXplainTable(lcc, schemaName,
                new XPLAINResultSetTimingsDescriptor());
        createXplainTable(lcc, schemaName,
                new XPLAINScanPropsDescriptor());
        createXplainTable(lcc, schemaName,
                new XPLAINSortPropsDescriptor());
        lcc.setRunTimeStatisticsMode(statsSave);
        lcc.setXplainSchema(schemaName);
    }
View Full Code Here
229
230
231
232
233
234
235
236
237
238
239
240
    public Object getSortPropsDescriptor(Object sortPropsID)
    {
        Properties props = this.sortProperties;
       
        // create new scan info descriptor with some basic information
        XPLAINSortPropsDescriptor sortRSDescriptor =           
          new XPLAINSortPropsDescriptor(
              (UUID)sortPropsID,      // the sort props UUID
              null,             // the sort type, either (C)onstraint, (I)ndex or (T)able
              null,                // the number of input rows
              null,                // the number of output rows
              null,                // the number of merge runs
View Full Code Here
241
242
243
244
245
246
247
248
249
250
251
252
    public Object getSortPropsDescriptor(Object sortPropsID)
    {
        FormatableProperties props = this.sortProperties;
       
        // create new scan info descriptor with some basic information
        XPLAINSortPropsDescriptor sortRSDescriptor =           
          new XPLAINSortPropsDescriptor(
              (UUID)sortPropsID,      // the sort props UUID
              null,             // the sort type, either (C)onstraint, (I)ndex or (T)able
              null,                // the number of input rows
              null,                // the number of output rows
              null,                // the number of merge runs
View Full Code Here
146
147
148
149
150
151
152
153
154
155
156
            rsetsTimings.add(
                    statistics.getResultSetTimingsDescriptor(timingID));
        }
       
        UUID sortID = dd.getUUIDFactory().createUUID();
        XPLAINSortPropsDescriptor sortRSDescriptor = (XPLAINSortPropsDescriptor) statistics.getSortPropsDescriptor(sortID);
        if (sortRSDescriptor != null)
            sortrsets.add(sortRSDescriptor);
        else
            sortID = null;
       
View Full Code Here
410
411
412
413
414
415
416
417
418
419
420
421
422
        ps = conn.prepareStatement(
            (String)lcc.getXplainStatement("SYSXPLAIN_SORT_PROPS"));
        Iterator<XPLAINSortPropsDescriptor> sortiter = sortrsets.iterator();
        while (sortiter.hasNext())
        {
            XPLAINSortPropsDescriptor sortProps =
                sortiter.next();
            sortProps.setStatementParameters(ps);
            ps.executeUpdate();
        }
        ps.close();

        conn.close();
View Full Code Here
2149
2150
2151
2152
2153
2154
2155
2156
2157
        createXplainTable(lcc, schemaName,
                new XPLAINResultSetTimingsDescriptor());
        createXplainTable(lcc, schemaName,
                new XPLAINScanPropsDescriptor());
        createXplainTable(lcc, schemaName,
                new XPLAINSortPropsDescriptor());
        lcc.setRunTimeStatisticsMode(statsSave);
        lcc.setXplainSchema(schemaName);
    }
View Full Code Here
228
229
230
231
232
233
234
235
236
237
238
239
    public Object getSortPropsDescriptor(Object sortPropsID)
    {
        Properties props = this.sortProperties;
       
        // create new scan info descriptor with some basic information
        XPLAINSortPropsDescriptor sortRSDescriptor =           
          new XPLAINSortPropsDescriptor(
              (UUID)sortPropsID,      // the sort props UUID
              null,             // the sort type, either (C)onstraint, (I)ndex or (T)able
              null,                // the number of input rows
              null,                // the number of output rows
              null,                // the number of merge runs
View Full Code Here
TOP

Related Classes of org.apache.derby.impl.sql.catalog.XPLAINSortPropsDescriptor

  • org.apache.derby.catalog.SystemProcedures
  • org.apache.derby.impl.sql.execute.rts.RealGroupedAggregateStatistics
  • org.apache.derby.impl.sql.execute.rts.RealSortStatistics
  • org.apache.derby.impl.sql.execute.xplain.XPLAINSystemTableVisitor
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.