Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL Tunning
Consider the following statement.
select first_name, last_name from table_adress where address_id is null;
Eventhough address_id is indexed uniquely, there is a full table scan. Is there a way to force index use without changing the sql statement?
Thanks in advance
Roman
Received on Sat Mar 20 1999 - 19:01:35 CST