Re: NOT IN conditions are extremly SLOW

> SELECT
> COUNT(*)
> FROM
> (SELECT
> COL_A,COL_B
> FROM
> TABLE_A
> MINUS
> SELECT
> COL_A,COL_B
> FROM
> TABLE_B
> )

Your statement is much faster, thank you.

But how do I get all columns of TABLE_A selected?

SELECT * FROM (SELECT COL_A, COL_B FROM TABLE_A MINUS SELECT COL_A, COL_B FROM TABLE_B) only retrieves columns COL_A and COL_B, but I would like to have all columns of TABLE_A

Robert Received on Thu Oct 06 2005 - 03:22:00 CDT