I'd be interested in seeing a tkprof for:
Code:
SELECT DISTINCT EMPLID
, ROWSECCLASS
, ACCESS_CD
, EMPL_RCD
, NAME
, LAST_NAME_SRCH
, SETID_DEPT
, DEPTID
, NAME_AC
, PER_STATUS
FROM PS_PERS_SRCH_FST
...and...

Code:
SELECT EMPLID
, ROWSECCLASS
, ACCESS_CD
, EMPL_RCD
, NAME
, LAST_NAME_SRCH
, SETID_DEPT
, DEPTID
, NAME_AC
, PER_STATUS
FROM PS_PERS_SRCH_FST