I quite agree with previous explainings, but there is idea how you can force
using index.
Why don't you fill this field with some special value ? (-1 for example). So
you can
check this field if it equals -1.
Roman Gelfand wrote <7d1gae$diu$1_at_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 Sun Mar 21 1999 - 12:22:55 CST
