Slow response on a query

From: Álvaro Palma Aste <queria_direccion_at_el.perla?>
Date: 17 Dec 2001 20:57:42 GMT
Message-ID: <9vlm86$b18$1_at_news.cec.uchile.cl>



Hi.

[Quoted] 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
Received on Mon Dec 17 2001 - 21:57:42 CET

Original text of this message