Mayur  Gujrathi
when to use clustered and non clustered index?
By Mayur Gujrathi in SQL Server on Mar 20 2016
  • Mayur  Gujrathi
    Mar, 2016 20

    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 shall we use non clustered always..

    • 0

Most Popular Job Functions