Re: ** SQL QUERY TUNING

You could use a set operation
eg.

select * from table where tab_column = 1 union
select * from table where tab_column is not null

or apply DeMorgans ....

select * from table where
NOT ( tab_column != 1 and tab_column is null)

Andy Tasker
Spirocom Analysts Ltd

Jürgen Kling wrote in message <353770A0.35DD_at_w-4.de>...
>Who can help me to optimize the following SQL-Statement
>
>
>
>select * from table
>
>where tab_column = 1
>
> or tab_column is null
>
>
>
>Thje column TAB_COLUMN having an index, but ORACLE cant't use it. Thus
>
>Oracle do an Full Table scan.
>
>
>
>
>
>jkling_at_w-4.de
Received on Fri Apr 17 1998 - 12:25:47 CDT