Tweet
How to check access paths of PF
Hi All,
It says that if we are creating multiple LF?s over a same PF then the access path could get shard among the created LF?s and it is depend upon the key field definitions.
For example:
If my 1st LF is having 3 key fields and then again I am creating the second LF over same PF with first two key fields same from 1st LF then in this case only one access path is created for a PF.
Therefore is there any way to see an access path of LF OR any CL command to check this OR how we come to know that how many access paths are created over that PF?
......
It says that if we are creating multiple LF?s over a same PF then the access path could get shard among the created LF?s and it is depend upon the key field definitions.
For example:
If my 1st LF is having 3 key fields and then again I am creating the second LF over same PF with first two key fields same from 1st LF then in this case only one access path is created for a PF.
Therefore is there any way to see an access path of LF OR any CL command to check this OR how we come to know that how many access paths are created over that PF?
......
Comment