Version: 9.0.x
I see this message even for those tables with no partitions:
table source: v_monitor.query_events
event_type: STORAGE_CONTAINERS_ELIMINATED
event_details: "Using only 3 stores out of 6 for projection myschema.mytable_b0"
how is this possible? Does this mean I get the benefit of pruning even if the table is not partitioned?
Is the pruning coming from how the table's projection is segmented?
If this is true, then what is the difference between pruning from a partitioned table vs a non partitioned table?