Learnt something newly from Oracle product documentation, its about pruning on Hash partitioned columns. Oracle Database prunes partition...