What is table partitioning? Explain range, list, and hash partitioning with partition pruning.

Answer preview

Partitioning splits one logical table into physical child tables so queries touch only relevant partitions (partition pruning). It is not sharding — all partitions still live on one database instance.…