Why column Store Index are suitable for large data warehouses?

 Posted by Niladri.Biswas on 4/29/2013 | Category: Sql Server Interview questions | Views: 2585 | Points: 40
Answer:

Data modifications like INSERT, UPDATE, and DELETE statements, are disallowed in the case of Column Store Index. For this reason, column store indexes are ideally situated for large data warehouses where the data is not changed that
frequently.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response