MVSFORUMS.com

[Meena]

hi,

I have a partitioned table space whch is partitioned on DEPT key and so is the index I1 defined on DEPT key.
If i define another non-partitioned index say I2 on ID and Name , then when i use this index , what scan will DB2 perfrom.

Example

If i have such a condition as..
The same ID+NAME can occur in different DEPT , then when i execute a query which includes ID and NAME chk in the where clause , then DB2 has to scan all the partitions to get the data.
In this case how will the index I2 be used?

[CZerfas]

Hi Meena,

where is the point?

With the predicates on ID and NAME in the where clause a couple of qualifying RIDs will be identified, and these rows will be read via the normal access possibilities:
- direct read if they are distributed randomly
- asynchronously if sequential detection is "fired"

regards
Christian