Showing posts with label zindex1. Show all posts
Showing posts with label zindex1. Show all posts

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