| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> ** SQL QUERY TUNING
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 - 10:08:03 CDT
 |
 |