Database Tuning (MOSC)

MOSC Banner

Left Outer Join - Full Table Scan on Both Table

edited Aug 28, 2012 12:31PM in Database Tuning (MOSC) 9 commentsAnswered
Dear Experts,

We have an SQL seleting Two Table records using Left Outer Join doing Full Table scan on both Table. How do we avoid the Full Table Scan.

      select A.EMPNO,A.ENAME from EMP A

              LEFT OUTER JOIN EMP1 B 

     ON A.EMPNO= B.EMPNO

    We do have primary key on both Tables compination of EMPNO

    Your expertise help is required to change the logic without doing full table scan.

Regards

Mudhalvan M.M

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center