Re: algorithm DB problem

The fastest algorithm I found for now :

select decode(my_column_1, null, 0, 1), decode(my_column_2, null, 0, 1), ... from my_table_1
...
(the same for 100 tables).
and so there is one full table scan for each table.

Thanks :) Received on Sun Jun 04 2006 - 11:01:27 CDT