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