Re: SQL Tunning

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Sun, 21 Mar 1999 22:16:08 +0000
Message-ID: <36F56FA8.45D82B7F@rdbms.freeserve.co.uk>

Roman,

Sybrand, Andrew and Serge are right about b-tree indexes, but is the column a candidate for a bitmap index, which will store null values.

Chris.

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 Sun Mar 21 1999 - 16:16:08 CST