• i couldnt upload the sql plan file due to server problem...

    i m posting my queries.

    Query 1:select a.ACCESS_ID as accessId,a.ROLE_ID as dmsRespId,a.USER_ID as dmsUserId,

    (select NAME as wfRespName From HR_JOBS yy where yy.JOB_ID=a.ROLE_ID) as wfRespName,

    (select FIRST_NAME as wfUserName From HR_PERSONS xx where xx.person_id=a.USER_ID) as wfUserName

    from SY_DMS_AUTHORIZATION a where a.ACCESS_ID=6

    Query 2: select a.ACCESS_ID as accessId,yy.JOB_ID as dmsRespId,a.USER_ID as dmsUserId,

    yy.NAME as wfRespName ,

    xx.FIRST_NAME as wfUserName

    from SY_DMS_AUTHORIZATION a left outer join HR_JOBS yy on yy.JOB_ID=a.ROLE_ID and a.ACCESS_ID=6 left outer join HR_PERSONS xx on xx.person_id=a.user_id

    Query 3: select a.ACCESS_ID as accessId,yy.JOB_ID as dmsRespId,a.USER_ID as dmsUserId,

    yy.NAME as wfRespName ,

    xx.FIRST_NAME as wfUserName

    from SY_DMS_AUTHORIZATION a left outer join HR_JOBS yy on yy.JOB_ID=a.ROLE_ID and a.ACCESS_ID=6 left outer join HR_PERSONS xx on xx.person_id=a.user_id

    all of them resulting same records....

    which one is fastest?... How can i find out the query which results fastly?