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 |
|
fasihakbar590
Starting Member
4 Posts |
 Posted - 2010-12-22 : 04:42:57
|
| Hi,I have read this statement in an article:-"Inserts and deletes will affect all nonclustered indexes on a table."Now I have two questions:-1) First question is that when we will perform operations(like Insert/Update/Delete) on a table then will we need to update our clustered/nonclustered indexes explicitly by query or they will be automatically updated ?2) Second question is:-Can anyone send me the steps to create clustered & nonclustered indexes(By SQL Query and by some other way in SQL Server) on a table?Thanks in advance.M.Fasih AKbarfasihakbar590 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-12-22 : 05:39:05
|
| 1) Automatically updated2) See documentation under CREATE INDEX - http://msdn.microsoft.com/en-us/library/ms188783.aspx |
 |
|
|
|
|
|
Clustered / Non-Clustered Indexes Creation