need to understand merge join cartesian plan
From: joshuasingham <joshuasingham_at_gmail.com>
Date: Sun, 17 Jan 2010 23:14:23 +0800
Message-ID: <74e7b3b01001170714j2d897393sb01a2c30c6675cc1_at_mail.gmail.com>
Hi all,
Date: Sun, 17 Jan 2010 23:14:23 +0800
Message-ID: <74e7b3b01001170714j2d897393sb01a2c30c6675cc1_at_mail.gmail.com>
Hi all,
I have a excerpt for a execution plan that look like below �which i got from dbms.xplan display cursor and would like to know why when the merge join cartesian happens Oracle estimate that the will be only 1 row return should it not be 36080 * 1 = 36080 as this is a Cartesian join the Db version is 10.2.0.3
| 4 | MERGE JOIN CARTESIAN |
| 1 | 63 | 252K (1)| 00:42:57 |
| |
| 5 | TABLE ACCESS FULL | GL_CODE_COMBINATIONS |
36080 | 1761K| 176 (2) | 00:00:02 | | |
| 6 | BUFFER SORT |
| 1 | 13 | 18E(100)|999:59:59
| | |
| 7 | VIEW | VW_NSO_1
| 1 | 13 | 7 (0)| 00:00:01 |
| |
thanks
Joshua
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Jan 17 2010 - 09:14:23 CST