Re: 8i join and 10g ANSI join syntax

From: Prasath <prasath.rao_at_gmail.com>
Date: 2 Feb 2006 03:56:36 -0800
Message-ID: <1138881396.734568.320570@g44g2000cwa.googlegroups.com>

SQL> select index_name from user_indexes where table_name = 'EMP';

no rows selected

SQL> select * from table(dbms_xplan.display);

PLAN_TABLE_OUTPUT

---

Plan hash value: 2285423260

---

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time   |

---

| 0 | SELECT STATEMENT | | 2 | 102 | 7 (15)| 00:00:01 |
|* 1 | HASH JOIN | | 2 | 102 | 7 (15)| 00:00:01 |
|* 2 | TABLE ACCESS FULL| EMP | 2 | 58 | 3 (0)| 00:00:01 |
| 3 | TABLE ACCESS FULL| DEPT | 4 | 88 | 3 (0)| 00:00:01 |

---

PLAN_TABLE_OUTPUT

---

Predicate Information (identified by operation id):

---

   1 - access("EMP"."DEPTNO"="DEPT"."DEPTNO")    2 - filter("EMP"."HIREDATE">SYSDATE@!-300)

Note

---

• dynamic sampling used for this statement

I see from this output that the filter is applied before the join. Let me know if I am interpreting the results correctly.

Thanks,
Prasath Received on Thu Feb 02 2006 - 05:56:36 CST