Re: SQL Tunning

Hi Roman,

Your problem is that NULL's are not indexed, so the only way to determine if the ADDRESS_ID column contains a NULL is to scan the table.

Sorry about that,
Andrew

Roman Gelfand wrote:

> 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 - 23:59:06 CST