Interviewer asked me the difference between clustered and non-clustered index and than moved further into it and asked one more question - When a table has a clustered index and a non-clustered index, do the non-clustered index still points to the data row in the table? I said yes, and immediately I thought it is wrong. Does it points towards the data row that is ordered by clustered index or the original data rows? Can someone throw some light on this please.
No comments:
Post a Comment