Concatenated Index

If I have a concatenated index on tablea columns (a, b, c) and a query:

SELECT count(*)
FROM tablea,
tableb
WHERE tablea.a like 'AB%'
 AND tablea.b=tableb.b
AND tablea.c=tableb.c

Will columns b and c of the index on tablea be used in the query? It uses the index like I wanted but I don't get the speed I think I should which leads me to believe that it doesn't.

Any help would be appreciated.

Thanks...
Steve Received on Tue Jun 04 2002 - 14:40:51 CDT