Understanding Indexing Process... 1

[nrugado]

I have set indexes on several columns/tables through out my database when I designed it.
The one thing that I am not sure of is, as data is added does sql server keep track of the new data and reindex the data as it comes in or is this something that needs to be performed as a task later initiated by me?
I have noticed that some things are slowing down so that is why I ask. Any help understanding how the process works would be greatly appreciated.

Thanks Nick

 

[JohnDTampaBay]

SQL Server keeps the indexes updated as data is inserted, deleted, or updated in the table. Tables that are updated heavy can become fragmented - and so can the associated indexes. Fragmented tables and indexes can, indeed, affect performance.

Check out DBCC INDEXDEFRAG and DBCC DBREINDEX in BOL. The maintenance plan wizard also addresses this. Check out Update Data Optimization Information. Good luck!



--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.

 

[nikhilparchure]

Also reindexing tables periodically and using update statistics also help in speeding up performance .

But all comes down to the queries that are run againsts the
database.It is neccessary that u'r queries are using indexes
and not going for a table scan.

Using Query Plan and using Tracing can help u analysing your database.

please refer to BOL for the above...

Parchure Nikhil