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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment