Improving performance of large partitioned tables
Hi All,
I need some help on how to improve the performance of a large partition table. This table has around 100Mil rows & are partitioned by range, due to the huge number of data entered each partition has about 800k to 1M rows each. Even with partitioned this doesn't give huge performance boost. Also this table doesn't have any index partition on it.
SQL> explain plan for select * from <xxtable> where datetime between '2017-12' and '2018-01';Explained.Elapsed: 00:00:00.01
SQL> select plan_table_output from
table(dbms_xplan.display('plan_table',null,'typical -cost -bytes')); 2PLAN_TABLE_OUTPUT
0