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,

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-l
Received on Sun Jan 17 2010 - 09:14:23 CST

Original text of this message