Home Forums SQL Server 2012 SQL 2012 - General SQL 2012 - Interview Questions (Sample) RE: SQL 2012 - Interview Questions (Sample)

  • December 14, 2017 at 5:04 am

    #1972112

    subramaniam.chandrasekar - Thursday, December 14, 2017 2:19 AM

    Question 2 :

    What are row and column store indexes, explain ?

    Row store indexes are used in OLTP tables in DB, where the indexes are created on transactional tables and the indexes are stored as pointers in RAM like rows.

    Column store indexes are used in OLAP tables In data warehouse, where the indexes are created on analytical / non transactional tables.

    But what about using nonclustered indexes on a clustered columnstore? What about using nonclustered columnstores on a clustered row store index? I think the answer here is quite a bit more nuanced and detailed.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning