Partiton level independence by NPI

desiz db2 consultant

Partiton level independence by NPI
Hi Group, here is doubt I do have. I have a partitioned table with 64 partitions. I do have NPI with partitioning index. The PIECESIZE calculation lead me to 6 pieces for that NPI. As I know the partion level independence would not be there for utilities when we do need to run that. My question is we could sacrifice some efforts for utilities, but to what much i would get the benefit for parallelism for NPI with 6 pieces. I had certain queries which are taking more CPU time when check its cost. This says me I should go for more benefit of partioning the NPI. Shall I make the same NPI pieces as of number of partions.Waiting for all suggestions.

Desiz
--

_______________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup


1 cent a minute calls anywhere in the U.S.!

http://www.getpennytalk.com/cgi-bin/adforward.cgi?p_key=RG9853KJ&url=http://www.getpennytalk.com




desiz db2 consultant

Fw: Partiton level independence by NPI
(in response to desiz db2 consultant)
Hi Group I m sending this again as I m waiting for some resoponses.
-----Original Message-----
From: "desiz db2 consultant" <[login to unmask email]>
Sent: Thu, 27 Dec 2001 13:24:33 +0800
To: [login to unmask email]
Subject: Partiton level independence by NPI

Hi Group, here is doubt I do have. I have a partitioned table with 64 partitions. I do have NPI with partitioning index. The PIECESIZE calculation lead me to 6 pieces for that NPI. As I know the partion level independence would not be there for utilities when we do need to run that. My question is we could sacrifice some efforts for utilities, but to what much i would get the benefit for parallelism for NPI with 6 pieces. I had certain queries which are taking more CPU time when check its cost. This says me I should go for more benefit of partioning the NPI. Shall I make the same NPI pieces as of number of partions.Waiting for all suggestions.

Desiz
--

_______________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup


1 cent a minute calls anywhere in the U.S.!

http://www.getpennytalk.com/cgi-bin/adforward.cgi?p_key=RG9853KJ&url=http://www.getpennytalk.com



--

_______________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup


1 cent a minute calls anywhere in the U.S.!

http://www.getpennytalk.com/cgi-bin/adforward.cgi?p_key=RG9853KJ&url=http://www.getpennytalk.com