addProperty(gen, "Partitioning", gp.getPartitioning().name()); if (gp.getPartitioningFields() != null) { addProperty(gen, "Partitioned on", gp.getPartitioningFields().toString()); addProperty(gen, "Partitioning Order", gp.getPartitioningOrdering().toString()); addProperty(gen, "Partitioning Order", "(none)"); addProperty(gen, "Uniqueness", "not unique"); addProperty(gen, "Uniqueness", optNode.getUniqueFields().toString()); addProperty(gen, "Order", lp.getOrdering().toString()); addProperty(gen, "Order", "(none)"); addProperty(gen, "Grouped on", lp.getGroupedFields().toString()); } else { addProperty(gen, "Grouping", "not grouped"); addProperty(gen, "Uniqueness", "not unique"); addProperty(gen, "Uniqueness", optNode.getUniqueFields().toString()); addProperty(gen, "Est. Output Size", optNode.getEstimatedOutputSize() == -1 ? "(unknown)" : formatNumber(optNode.getEstimatedOutputSize(), "B")); addProperty(gen, "Est. Cardinality", optNode.getEstimatedNumRecords() == -1 ? "(unknown)" : formatNumber(optNode.getEstimatedNumRecords()));
addProperty(gen, "Partitioning", gp.getPartitioning().name()); if (gp.getPartitioningFields() != null) { addProperty(gen, "Partitioned on", gp.getPartitioningFields().toString()); addProperty(gen, "Partitioning Order", gp.getPartitioningOrdering().toString()); addProperty(gen, "Partitioning Order", "(none)"); addProperty(gen, "Uniqueness", "not unique"); addProperty(gen, "Uniqueness", optNode.getUniqueFields().toString()); addProperty(gen, "Order", lp.getOrdering().toString()); addProperty(gen, "Order", "(none)"); addProperty(gen, "Grouped on", lp.getGroupedFields().toString()); } else { addProperty(gen, "Grouping", "not grouped"); addProperty(gen, "Uniqueness", "not unique"); addProperty(gen, "Uniqueness", optNode.getUniqueFields().toString()); addProperty(gen, "Est. Output Size", optNode.getEstimatedOutputSize() == -1 ? "(unknown)" : formatNumber(optNode.getEstimatedOutputSize(), "B")); addProperty(gen, "Est. Cardinality", optNode.getEstimatedNumRecords() == -1 ? "(unknown)" : formatNumber(optNode.getEstimatedNumRecords()));
addProperty(gen, "Partitioning", gp.getPartitioning().name()); if (gp.getPartitioningFields() != null) { addProperty(gen, "Partitioned on", gp.getPartitioningFields().toString()); addProperty(gen, "Partitioning Order", gp.getPartitioningOrdering().toString()); addProperty(gen, "Partitioning Order", "(none)"); addProperty(gen, "Uniqueness", "not unique"); addProperty(gen, "Uniqueness", optNode.getUniqueFields().toString()); addProperty(gen, "Order", lp.getOrdering().toString()); addProperty(gen, "Order", "(none)"); addProperty(gen, "Grouped on", lp.getGroupedFields().toString()); } else { addProperty(gen, "Grouping", "not grouped"); addProperty(gen, "Uniqueness", "not unique"); addProperty(gen, "Uniqueness", optNode.getUniqueFields().toString()); addProperty(gen, "Est. Output Size", optNode.getEstimatedOutputSize() == -1 ? "(unknown)" : formatNumber(optNode.getEstimatedOutputSize(), "B")); addProperty(gen, "Est. Cardinality", optNode.getEstimatedNumRecords() == -1 ? "(unknown)" : formatNumber(optNode.getEstimatedNumRecords()));
addProperty(gen, "Partitioning", gp.getPartitioning().name()); if (gp.getPartitioningFields() != null) { addProperty(gen, "Partitioned on", gp.getPartitioningFields().toString()); addProperty(gen, "Partitioning Order", gp.getPartitioningOrdering().toString()); addProperty(gen, "Partitioning Order", "(none)"); addProperty(gen, "Uniqueness", "not unique"); addProperty(gen, "Uniqueness", optNode.getUniqueFields().toString()); addProperty(gen, "Order", lp.getOrdering().toString()); addProperty(gen, "Order", "(none)"); addProperty(gen, "Grouped on", lp.getGroupedFields().toString()); } else { addProperty(gen, "Grouping", "not grouped"); addProperty(gen, "Uniqueness", "not unique"); addProperty(gen, "Uniqueness", optNode.getUniqueFields().toString()); addProperty(gen, "Est. Output Size", optNode.getEstimatedOutputSize() == -1 ? "(unknown)" : formatNumber(optNode.getEstimatedOutputSize(), "B")); addProperty(gen, "Est. Cardinality", optNode.getEstimatedNumRecords() == -1 ? "(unknown)" : formatNumber(optNode.getEstimatedNumRecords()));
addProperty(gen, "Partitioning", gp.getPartitioning().name()); if (gp.getPartitioningFields() != null) { addProperty(gen, "Partitioned on", gp.getPartitioningFields().toString()); addProperty(gen, "Partitioning Order", gp.getPartitioningOrdering().toString()); addProperty(gen, "Partitioning Order", "(none)"); addProperty(gen, "Uniqueness", "not unique"); addProperty(gen, "Uniqueness", optNode.getUniqueFields().toString()); addProperty(gen, "Order", lp.getOrdering().toString()); addProperty(gen, "Order", "(none)"); addProperty(gen, "Grouped on", lp.getGroupedFields().toString()); } else { addProperty(gen, "Grouping", "not grouped"); addProperty(gen, "Uniqueness", "not unique"); addProperty(gen, "Uniqueness", optNode.getUniqueFields().toString()); addProperty(gen, "Est. Output Size", optNode.getEstimatedOutputSize() == -1 ? "(unknown)" : formatNumber(optNode.getEstimatedOutputSize(), "B")); addProperty(gen, "Est. Cardinality", optNode.getEstimatedNumRecords() == -1 ? "(unknown)" : formatNumber(optNode.getEstimatedNumRecords()));