Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL Tunning

SQL Tunning

From: Roman Gelfand <rgelfand_at_masmid.com>
Date: Sat, 20 Mar 1999 20:01:35 -0500
Message-ID: <7d1gae$diu$1@news.monmouth.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US