Optimization of a query with NVL in the where part

Hi there!

Suppose we have tab_a and tab_b: 2 column the first 4 the second and we want to do this query:

Select tab_b.c3,tab_a.c2
 From tab_a,tab_b
Where nvl(tab_a.c1,tab_a.c2) = nvl(tab_b.c1,tab_b.c2)

What can we do?
It's quite simple to write, but when the table become HUGE...

Hope for help! Received on Mon May 21 2001 - 13:53:15 CDT