Indexes

mp3909

Well-known member
Joined
Apr 22, 2018
Messages
61
Location
UK
Programming Experience
3-5
Hi,

After spending some time understanding indexes in Mircrosoft SQL Server, I have a few questions:

  1. I understand data retrieval (i.e. Select statement) is quicker in a clustered index than a non-clustered index. But is this only true if and only if the columns you would like to get back are not defined in the non-clustered index? Otherwise, they both pretty much the same
  2. How does insert, update and delete statements affect a table with a non-clustered index? - my feeling is that only INSERT and UPDATE would be slow since the non-clustered indexes will need to be reshuffled/modified. DELETE will have no impact.
  3. How does insert, update and delete statement affect a table with a clustered index? - my feeling is that only INSERT and UPDATE would be slow since the non-clustered indexes will need to be reshuffled/modified. DELETE will have no impact.


If I am wrong, please explain.
Much appreciated.
 
Back
Top Bottom