SQL-statment tuning

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 Fri Apr 17 1998 - 09:55:01 CDT