Home » RDBMS Server » Performance Tuning » hash partitioning.. help.
hash partitioning.. help. [message #234001] Sat, 28 April 2007 19:14 Go to next message
a_developer
Messages: 194
Registered: January 2006
Senior Member
I have a table which I made into a hash-partitioned. Before partitioning, i used to insert records in that table in just 5 minutes - around 25000 rows inserted. After partitioning, it became 20 mins to insert 25000 rows. My partition key is the Primary Key and I have created 9 indexes (btree) on each partition (6 of them).

I found that my query on this table improved after I partitioned. But insert is taking long time. Please help.
Re: hash partitioning.. help. [message #234019 is a reply to message #234001] Sun, 29 April 2007 01:49 Go to previous message
michael_bialik
Messages: 621
Registered: July 2006
Senior Member
Run your insert statements with event 10046.

Post TKPROF with wait times.
Previous Topic: MERGE statement tuning
Next Topic: Please help find the problem
Goto Forum:
  


Current Time: Tue Dec 03 18:22:42 CST 2024