|
View previous topic :: View next topic
|
| Author |
Message |
Pradip kumar Mohanty
New User
Joined: 16 Sep 2007
Posts: 33
Location: India
|
|
|
|
| What are the performance implications with "Number of data CA is greater than number of Index records" ? |
|
| Back to top |
|
 |
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA
|
|
|
|
| There's not much of a performance impact -- it just means that some of your DATA CI cannot be accessed, so the data set will be larger than it would be if the INDEX CI size were set correctly. |
|
| Back to top |
|
|
Pete Wilson
Active Member
Joined: 31 Dec 2009
Posts: 582
Location: London
|
|
|
|
What level of Z/OS are you on, this issue was eliminated in around v1.10 or so I thought.
Having a larger INDEX CISIZE can help especially if you have long keys, but I'm sure in later releases DFP will ensure the INDEX CI's are large enough so that all DATA CI's can be referenced. |
|
| Back to top |
|
|
|
|
