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.
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.adivinaReceived on Mon Dec 17 2001 - 21:57:42 CET
