Indexes

Hi,
I am new to SQL 2000. We have bought the full version and
we have created some tables with large numbers of records
(20m, 60m etc...) but I wish to know more about Indexes
and all the different types within SQL 2000 and which one
to use and for what.
Clustered and Non-clustered needs to be explained in laman
terms please.
Thanks,
Skcsks
Look ath the following articles
http://www.sql-server-performance.c...ing_indexes.asp
http://www.sql-server-performance.c...red_indexes.asp
http://www.sql-server-performance.c...ite_indexes.asp
http://www.sql-server-performance.c...ing_indexes.asp
http://www.sql-server-performance.c...red_indexes.asp
"skc" <anonymous@.discussions.microsoft.com> wrote in message
news:e20f01c40b3f$88983c60$a101280a@.phx.gbl...
> Hi,
> I am new to SQL 2000. We have bought the full version and
> we have created some tables with large numbers of records
> (20m, 60m etc...) but I wish to know more about Indexes
> and all the different types within SQL 2000 and which one
> to use and for what.
> Clustered and Non-clustered needs to be explained in laman
> terms please.
> Thanks,
> Skc