Why do you think you should?
You already have an index on column A (A being the leftmost column of your
AB index)
If you'd have a BITMAP index on A then it could be a different story, but it
all depends on your data.
--
Syltrem
OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"Laly" <lalystar_at_free.fr> a écrit dans le message de
news:3fd2e266$0$29089$636a55ce_at_news.free.fr...
> Hello,
>
>
> Suppose we have a huge table T(a, b, ...)
> There is a primary key on (a, b).
> Can we gain some time on queries like
> select *
> from T
> where a = ...
> by creating a new nonunique index on column a.
>
>
> Thanks in advance,
>
>
> Laly.
>
>
>
>
>
Received on Thu Dec 11 2003 - 09:00:55 CST
