DB2 Vs Hash partition technique

HariD · Post by **HariD** » Mon Mar 22, 2010 7:46 am

I have db2 data so i have to apply partition technique on the data which partititon type gives more performance.

chulett · Post by **chulett** » Mon Mar 22, 2010 7:53 am

Try them both and let us know. Also, do you understand what 'DB2' as a partioning method does? Just because you have 'DB2 data' doesn't automagically mean you should be using it.

ArndW · Post by **ArndW** » Mon Mar 22, 2010 8:05 am

With a partitioned DB2 database you may use DB2 partitioning, but it is not required. Using it will give you better performance in parallel reads and writes, though.

chulett · Post by **chulett** » Mon Mar 22, 2010 8:31 am

Just to be clear... using it will give you better performance in parallel reads and writes, though, if you have a partitioned DB2 database.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 22, 2010 1:31 pm

Moderator: please move to Enterprise Edition (parallel) forum