A.Partitioning allows the database to prune unnecessary data during queries

B.You can define subpartitions within a partition

C.Partitions are automatically replicated across all segments

D.Partitioned tables cannot be analyzed using EXPLAIN

A.PL/R

B.MADlib

C.PostGIS

D.HDFS

A.Removing unused master nodes

B.Compressing data in existing partitions

C.Redistributing data for better performance

D.Adding new segment nodes for horizontal scaling

A.It forces data replication

B.It improves plan accuracy for large datasets

C.It re-indexes all primary keys

D.It gathers statistics for query optimization

A.Logical table

B.Distributed mirror table

C.Readable external table

D.Writable external table