Re: SQL-statment tuning

From: Pei L. Ku <pku_at_gte.net>
Date: 18 Apr 1998 19:36:51 GMT
Message-ID: <6havcj$683$3@gte2.gte.net>

Null is not your friend in this case....

A long, long shot -- have you looked at bit-map index? I don't think it would solve your problem, but I'm not sure...

Pei
Oracle DBA

Jürgen Kling <jkling_at_w-4.de> wrote in article <35376D45.16ED_at_w-4.de>...
> Who can help me to optimize the following SQL statment:
>
> select * from TABLE
> where TAB_COLUMN = 1
> or TAB_COLUMN is null
>
>
> the Column TAB_COLUMN havein an index, but Oracle can't use it.
> Thus Oracle do an Full Table scan.
>
> Do somebody now how to change this statement
>
>
> jkling_at_w-4.de
>
Received on Sat Apr 18 1998 - 14:36:51 CDT