indexes

Anyone can tell me the fast way to find out which columns
of the tables are indexed? Thanks.Either query sysindexes and sysindexkeys. Or use sp_helpindex.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bill" <fei0405@.yahoo.com> wrote in message news:019301c49b46$23315c70$a301280a@.phx.gbl...
> Anyone can tell me the fast way to find out which columns
> of the tables are indexed? Thanks.