Re: Select query takes long to execute

Nikolaus,

I think that shouldn't be any more effective. As I experienced, it's
irrelevant how many cols an index has as long as you only use the first
column. And, after that, if you use another column, how could a missing
second column be any better?

G.
------------------------------- cut here -------------------------------
----- Original Message -----
From: "Nikolaus Dilger" <nikolaus@dilger.cc>
Sent: Friday, May 30, 2003 4:44 AM


> Kevin,
>
> How about creating a new index just on column6?
> That should be much more effective than the multicolumn
> index.
>
> Regards,
> Nikolaus