Oracle-如何构建高效Oracle Partition.pptVIP

* Partition-Wise Join-full partition-wise join * Partition-Wise Join-partial partition-wise join * Partition-wise Joins举例 1 select /*+ full(c) */ c.customer_no, count(*) 2 from customers c, daily_trans_data d 3 where c.customer_no = d.customer_no 4 and d.trans_datetime between to_date(25-jun-2001,dd-mon-yyyy) 5 and to_date(28-jun-2001,dd-mon-yyyy) 6* group by c.customer_no Partition Partition Operation Options Object Name Start Stop