Indexes

Hello!
How can I check indexes ond the SQL server 2000 database? I think that it
should work much faster so I would like to check do I need to reindex
something or not. Is there any built in tool for this? Can I loose something
if I reindex some table?
Thx,
Marco
You should read this excellent whitepaper:
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Marko" <marko@.marko.mr> wrote in message news:d2dgjs$m31$1@.ss405.t-com.hr...
> Hello!
> How can I check indexes ond the SQL server 2000 database? I think that it
> should work much faster so I would like to check do I need to reindex
> something or not. Is there any built in tool for this? Can I loose something
> if I reindex some table?
> Thx,
> Marco
>