when to use clustered and non clustered index?
Mayur Gujrathi
i have been asked interview question so many times. i answer them if data is scattered on different pages then we can use non clustered index else clustered index for range of values..but on this interviewer asked as data page size is 8 kb data will be always scattered on different pages..so shall we use non clustered always..