Examples of PlanCostEstimator

Examples of com.foundationdb.sql.optimizer.rule.cost.PlanCostEstimator

1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
    public CostEstimate estimateCost(IndexScan index) {
        return estimateCost(index, queryGoal.getLimit());
    }

    public CostEstimate estimateCost(IndexScan index, long limit) {
        PlanCostEstimator estimator = newEstimator();
        Set<TableSource> requiredTables = index.getRequiredTables();

        estimator.indexScan(index);

        if (!index.isCovering()) {
            estimator.flatten(tables,
                              index.getLeafMostTable(), requiredTables);
        }

        Collection<ConditionExpression> unhandledConditions =
            new HashSet<>(requiredConditions);
        if (index.getConditions() != null)
            unhandledConditions.removeAll(index.getConditions());
        if (!unhandledConditions.isEmpty()) {
            estimator.select(unhandledConditions,
                             selectivityConditions(unhandledConditions, requiredTables));
        }

        if (queryGoal.needSort(index.getOrderEffectiveness())) {
            estimator.sort(queryGoal.sortFields());
        }

        estimator.setLimit(limit);

        return estimator.getCostEstimate();
    }
View Full Code Here

Examples of com.foundationdb.sql.optimizer.rule.cost.PlanCostEstimator

1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
        if (limit < 0)
            return index.getScanCostEstimate();
        // There is a limit and this index looks to be sorted, so adjust for that
        // limit. Otherwise, the scan only cost, which includes all rows, will appear
        // too large compared to a limit-aware best plan.
        PlanCostEstimator estimator = newEstimator();
        estimator.indexScan(index);
        estimator.setLimit(limit);
        return estimator.getCostEstimate();
    }
View Full Code Here

Examples of com.foundationdb.sql.optimizer.rule.cost.PlanCostEstimator

1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
1308
1309
1310
        estimator.setLimit(limit);
        return estimator.getCostEstimate();
    }

    public CostEstimate estimateCost(GroupScan scan) {
        PlanCostEstimator estimator = newEstimator();
        Set<TableSource> requiredTables = requiredColumns.getTables();

        estimator.groupScan(scan, tables, requiredTables);

        if (!requiredConditions.isEmpty()) {
            estimator.select(requiredConditions,
                             selectivityConditions(requiredConditions, requiredTables));
        }
       
        estimator.setLimit(queryGoal.getLimit());

        return estimator.getCostEstimate();
    }
View Full Code Here

Examples of com.foundationdb.sql.optimizer.rule.cost.PlanCostEstimator

1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
1325
1326
1327
1328
1329
1330
1331
1332
1333
1334
        return estimator.getCostEstimate();
    }

    public CostEstimate estimateCost(GroupLoopScan scan) {
        PlanCostEstimator estimator = newEstimator();
        Set<TableSource> requiredTables = scan.getRequiredTables();

        estimator.groupLoop(scan, tables, requiredTables);

        Collection<ConditionExpression> unhandledConditions =
            new HashSet<>(requiredConditions);
        addInnerJoinConditions(unhandledConditions, scan.getInsideTable());
        unhandledConditions.removeAll(scan.getJoinConditions());
        if (!unhandledConditions.isEmpty()) {
            estimator.select(unhandledConditions,
                             selectivityConditions(unhandledConditions, requiredTables));
        }

        if (queryGoal.needSort(IndexScan.OrderEffectiveness.NONE)) {
            estimator.sort(queryGoal.sortFields());
        }

        estimator.setLimit(queryGoal.getLimit());

        return estimator.getCostEstimate();
    }
View Full Code Here

Examples of com.foundationdb.sql.optimizer.rule.cost.PlanCostEstimator

1350
1351
1352
1353
1354
1355
1356
1357
1358
1359
1360
1361
1362
1363
1364
1365
1366
1367
1368
1369
1370
1371
1372
1373
1374
1375
1376
            output = output.getOutput();
        }
    }

    public CostEstimate estimateCost(ExpressionsHKeyScan scan) {
        PlanCostEstimator estimator = newEstimator();
        Set<TableSource> requiredTables = scan.getRequiredTables();

        estimator.hKeyRow(scan);
        estimator.flatten(tables, scan.getTable(), requiredTables);

        Collection<ConditionExpression> unhandledConditions =
            new HashSet<>(requiredConditions);
        unhandledConditions.removeAll(scan.getConditions());
        if (!unhandledConditions.isEmpty()) {
            estimator.select(unhandledConditions,
                             selectivityConditions(unhandledConditions, requiredTables));
        }

        if (queryGoal.needSort(IndexScan.OrderEffectiveness.NONE)) {
            estimator.sort(queryGoal.sortFields());
        }

        estimator.setLimit(queryGoal.getLimit());

        return estimator.getCostEstimate();
    }
View Full Code Here

Examples of com.foundationdb.sql.optimizer.rule.cost.PlanCostEstimator

1888
1889
1890
1891
1892
1893
1894
1895
1896
1897
1898
1899
1900
1901
1902
1903
1904
1905
1906
1907
1908
1909
1910
1911
1912
1913
1914
1915
1916
1917
            op = ((CastExpression)op).getOperand();
        return col.equals(op);
    }

    public CostEstimate estimateCostSpatial(SingleIndexScan index) {
        PlanCostEstimator estimator = newEstimator();
        Set<TableSource> requiredTables = requiredColumns.getTables();

        estimator.spatialIndex(index);

        if (!index.isCovering()) {
            estimator.flatten(tables, index.getLeafMostTable(), requiredTables);
        }

        Collection<ConditionExpression> unhandledConditions = new HashSet<>(requiredConditions);
        if (index.getConditions() != null)
            unhandledConditions.removeAll(index.getConditions());
        if (!unhandledConditions.isEmpty()) {
            estimator.select(unhandledConditions,
                             selectivityConditions(unhandledConditions, requiredTables));
        }

        if (queryGoal.needSort(index.getOrderEffectiveness())) {
            estimator.sort(queryGoal.sortFields());
        }

        estimator.setLimit(queryGoal.getLimit());

        return estimator.getCostEstimate();
    }
View Full Code Here

Examples of com.foundationdb.sql.optimizer.rule.cost.PlanCostEstimator

2196
2197
2198
2199
2200
2201
2202
2203
2204
        Set<TableSource> required = new HashSet<>(requiredAfter.getTables());
        scan.setRequiredTables(required);
    }

    public CostEstimate estimateCostFullText(FullTextScan scan) {
        PlanCostEstimator estimator = newEstimator();
        estimator.fullTextScan(scan);
        return estimator.getCostEstimate();
    }
View Full Code Here

Examples of com.foundationdb.sql.optimizer.rule.cost.PlanCostEstimator

2202
2203
2204
2205
2206
2207
2208
        estimator.fullTextScan(scan);
        return estimator.getCostEstimate();
    }

    protected PlanCostEstimator newEstimator() {
        return new PlanCostEstimator(queryGoal.getCostEstimator());
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.