Indexes updating.

hi.
pls guide me how to check whether indexes are updating or not..
i want to check whether inserts/updates are causing slowness and hampering performance of site bcox of unnecessary indexes..Hi Sanjay,
Get the query that you want to inspect into Query Analyzer and get the
estimated execution plan for it with Ctrl+L. You can now see what the query
will do during it's execution and whether it will update any indexes or not.
--
Jacco Schalkwijk
SQL Server MVP
"sanjay" <anonymous@.discussions.microsoft.com> wrote in message
news:AFF68260-5288-427E-A5CB-3EBDB15E0AAA@.microsoft.com...
> hi.
> pls guide me how to check whether indexes are updating or not..
> i want to check whether inserts/updates are causing slowness and hampering
performance of site bcox of unnecessary indexes..
>