Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is KEY in the partition start column?

Lakshmanarao JagarlamudiJul 15 2015 — edited Jul 15 2015

Hi,

I have an explain plan. As per my understanding, Pstart and Pstop columns contains the range of the partitions (Starting partition and Ending partition) where the search happens if there is a join on the partitioned column of a table. In this, I want to know what is the KEY in the column Pstart

Explain_Plan.jpg

Can any one please explain?

Thank you.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2015
Added on Jul 15 2015
5 comments
1,647 views