Re: ** SQL QUERY TUNING

From: kiel <kiel_at_webpre.com>
Date: Fri, 17 Apr 1998 08:58:45 -0500
Message-ID: <35376015.1794@webpre.com>

Jürgen Kling wrote:
>
> 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

Try this, haven't tried it myself just a thought, let me know if it helps

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

Christian Received on Fri Apr 17 1998 - 08:58:45 CDT