Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Case and the execution plan

Case and the execution plan

From: <sweidanz_at_yahoo.com>
Date: Thu, 18 Oct 2001 11:35:32 +1000
Message-ID: <nLJz7.8$8W.744@nsw.nnrp.telstra.net>


When i use a case in a query and the case is using another table(s), the execution plan does not show the tables in the case. for example,

SELECT column1, column2,

              CASE 
                    WHEN NOT EXISTS ( SELECT null 
                                                         FROM table_case1 
c1
                                                          WHERE c1.column1 

= table1.column1)
THEN 'column does not exist in table_case1' WHEN EXISTS (SELECT null FROM table_case2 c2 WHERE c2.column1

= table1.column1)
                         THEN 'column does not exist in table_case2'
                END AS description

 FROM table1, table2
where some conditions for table1, table2

In the excution plan Oracle does not show any access to table_case1 and table_case2. It only shows the joins for table1 and table2. Is that a normal behavior?

Thanks,
ZS Received on Wed Oct 17 2001 - 20:35:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US