Monday, March 19, 2012

Index not updated.

Hi,

We run SQL SERVER 2000 on win2000

I've a question regarding Index on a table.
I've a table (1 milj rows) with a extra index ZINDEX1.

Now lets say I insert 1000 rows in that table.

Now what will happend if I search on these NEW rows in my table.
The Index is not updated.

//Martinindices can become freagmented after large inserts. look up DBCC SHOWCONTIG, DBCC REINDEXDB and DBCC INDEXDEFRAG in books online. And here is a little more light reading...

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

No comments:

Post a Comment