Indexing an already filled table

[sethindeed]

Hello,
I have indexed an SQL Server table that already contains some records. I have been told that I have to run an SQL prompt before the changes are applied to the table. Is it true ? Do you know what is the SQL text I have to run to optimize my newly created Indexes ?
Thanx

 

[RickCole]

Check out the command UPDATE STATISTICS in Books Online.

Hope this helps.

Rick Cole

 

[foxdev]

I have been told that I have to run an SQL prompt before the changes are applied to the table.

This would be untrue, assuming we're discussing a regular index, not a full-text index. Robert Bradley

http://www.agrainofhope.org

http://www.lowcostprints.com

http://www.foxdev.com