Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
satish.gorijala
Posting Yak Master
182 Posts |
 Posted - 2009-04-02 : 06:54:25
|
| HI, i have a doubt on indexes.I have a created a non-cluster,non-unique index for a column in the table. When i am creating index for the table it has 500 rows. Later after some time, i deleted all records from that table and added newly 400 records to that table. Is index will automatically work on this?G. Satish |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2009-04-02 : 07:15:28
|
| Yes the index will work. |
 |
|
|
|
|
|
Can index will remain even if data deleted and add