Database DataWarehousing (MOSC)

MOSC Banner

INSERTS in REFERENCE PARTITION TABLES take twice as long as RANGE PARTITION TABLES

edited Jun 2, 2011 4:25AM in Database DataWarehousing (MOSC) 2 commentsAnswered
 I would like to use Reference Partition Tables but in Performance Testing I have noticed that doing Inserts into Reference Partition Tables take twice as long as doing inserts in Range Partition Tables.  My thoughts are that the additional time is required to determine the partition to insert the row into by looking up the primary key in the parent table.  I was wondering if anyone else has had this experience and if taking twice as long to insert a row is really the norm or if I should consider it an issue on the Exadata Oracle 11g RAC I am

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center