explain plan

[Roshan]

Oracle Database 11.1.0.7
AIX

Hi Erman,

I would like to know how I can check which part needs to be tuned/rewritten as per the explain plan attached.
explain.txt

Thanks,

Roshan

[ErmanArslansOracleBlog]

This seems okay.
Maybe the FTS that is done for retrieving data from HR_ALL_ORGANIZATION_UNITS..
And maybe the index range scan done for PER_ABSENCE_ATTENDANCES.
But this query already seems a very quick query.

[Roshan]

Thanks :)