Indexes...

Hi!
I am very new to SQL 2K. I have tables with indexes. Do I have to re-index (I used to do this on Fox Pro) them once in a while? If so, how can I do this?
Thank you!
yes
look up DBCC DBReindex AND DBCC IndexDefrag in books on line
and then read this white paper:
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
Cheers
Greg Jackson
PDX, Oregon
|||Depends on the kind of operations performed on the tables. For example, a
read-only table's indexes will not get fragmented.
You can defragment indexes using DBCC DBREINDEX and DBCC INDEXDEFRAG. You
can see fragmentation using DBCC SHOWCONTIG.
See SQL Server Books Online for more infromation on these commands, and for
examples.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:5789D06C-6A91-40F6-A639-5F2C84821706@.microsoft.com...
Hi!
I am very new to SQL 2K. I have tables with indexes. Do I have to re-index
(I used to do this on Fox Pro) them once in a while? If so, how can I do
this?
Thank you!
|||There is a great arcitle on this subject here:
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
HTH
Regards,
Greg Linwood
SQL Server MVP
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:5789D06C-6A91-40F6-A639-5F2C84821706@.microsoft.com...
> Hi!
> I am very new to SQL 2K. I have tables with indexes. Do I have to
re-index (I used to do this on Fox Pro) them once in a while? If so, how
can I do this?
> Thank you!