Creating new indexes

Hello all,
Just a quickie. If i add new indexes to tables, do I have to reanalyse /
reindex / do anything or is this done automatically by SQL Server? We're
running SQL Server 2000.
Thanks,
Jon
Yes correct, Whenever you Create/Rebuild/Drop n Create a index its
pages are Organized, and there is nothing much you can do on it.
But yes if your senario is highly intensive transactional (Lots of
Inserts n Deletes), Then u maye want to check back on the Index
Fragmentations.
On Jan 22, 1:36 pm, Jon <J...@.discussions.microsoft.com> wrote:
> Hello all,
> Just a quickie. If i add new indexes to tables, do I have to reanalyse /
> reindex / do anything or is this done automatically by SQL Server? We're
> running SQL Server 2000.
> Thanks,
> Jon
|||Hello,
If you add a clustered index automatically all the non clustered index
associated with that table will be recreated and its statistics will be
updated. If it is non clustered index
you may need to reindex all the other indexes individually or use DBCC
DBREINDEX('Tablename')
Thanks
Hari
"Jon" <Jon@.discussions.microsoft.com> wrote in message
news:F2A8A2B8-C395-49A6-8751-0D9592FF3D38@.microsoft.com...
> Hello all,
> Just a quickie. If i add new indexes to tables, do I have to reanalyse /
> reindex / do anything or is this done automatically by SQL Server? We're
> running SQL Server 2000.
> Thanks,
> Jon