Re: Open tables with Partitioning
If you compare opening 1000 tables to opening one table with 1000 partitions the partitioned table will be faster (only create one table object, one table_share object, only open one .frm file etc, the only thing that will be the same is that both have to create and open 1000 handlers).
The only thing I can come up with, when comparing, is that it will still have to lock each partition for each statement (unless you use LOCK TABLES around a bigger block of statements). So for small/fast queries against a heavily partitioned table there will be overhead for locking all partitions, but if you compare it to a 1000 way join it is still faster ;) Again this is bug#37252...
Subject
Views
Written By
Posted
4343
February 28, 2011 04:56AM
1607
February 28, 2011 10:03AM
2124
March 01, 2011 11:22PM
2340
March 02, 2011 03:06AM
1495
March 02, 2011 07:16AM
1631
March 02, 2011 07:29AM
1528
March 02, 2011 07:46AM
Re: Open tables with Partitioning
2302
March 02, 2011 08:20AM
1481
March 02, 2011 11:29AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.