Re: Slow response on a query

�lvaro Palma Aste wrote:
>
> Hi.
>
> I�ve a query which looks like this
>
> select a
> from b
> where c = value
>
> I also have an index for that query, and this works really fast.
>
> But if I replace my query:
>
> select a
> from b
> where c is not null
>
> it becomes really slow!!!. So my question is: Is there a way so I create an
> index for that query (over nulls fileds in a table)
>
> Thanks a lot
>
> --
> Atte.
> �lvaro Palma Aste
> Grupo de Ing. Biom�dica
> Depto. de Ing. El�ctrica - U. de Chile
> apalma_at_cec.uchile.adivina
No. NULL values are not represented in indexes. Look at using/creating a function based index using the NVL() function.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.