SQL query clarification

From: Ram Raman <veeeraman_at_gmail.com>
Date: Wed, 4 Jan 2017 22:25:29 -0600
Message-ID: <CAHSa0M0SFppPaZMRNjGMDHE99iV44ujkE1F_Xo3Xyodos86O9A_at_mail.gmail.com>



List

I was trying to tune a query in 11g EE. Here is the link: https://drive.google.com/open?id=0B9YC82qZ8_3eemF5b3kzTlh0eVU

I was looking at the plan and one thing i could not understand was ids 8 and 9 in the second plan (phv 1362929457). After getting the employeeid from the TIMESHEEITEM table, the optimizer selects the matching row from the jaids table. jaids table has PERSONID as primary key. Why would the optimizer say that it would (or really did) access all the 31.5K rows of JAIDS. Same question with PERSON table.

Ram.

--

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 05 2017 - 05:25:29 CET

Original text of this message