Hi,
After spending some time understanding indexes in Mircrosoft SQL Server, I have a few questions:
If I am wrong, please explain.
Much appreciated.
After spending some time understanding indexes in Mircrosoft SQL Server, I have a few questions:
- 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
- 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.
- 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.