Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Case and the execution plan
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
THEN 'column does not exist in table_case2' END AS description
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
![]() |
![]() |