composite index

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 Sun Dec 07 2003 - 02:18:31 CST