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?
An index doesn't contain NULL-values, so there's no index which is
useable in this case.
Bye:
--
.---, G o m b o s B e r t a l a n
: :
:---'-. ,---. ,--. ,-.-. rendszerfejleszto, Oracle mernok
: : :-- : ; mailto:bgombos_at_freemail.c3.hu
,' '---' '---' ' `-'
-- : ------------------------- Az elet megis egy habostorta? --- '10^2-1
Received on Mon Mar 22 1999 - 03:36:01 CST
