SQL Server Version - Columnstore - Segment elimination

• etl2016

  Default port

  Points: 1459

  More actions

  August 18, 2019 at 9:46 am

  #3672136

  Hi

  From docs of MS, its not very evident, which SQL version (onwards) has Segment Elimination feature available.   Is this available in 2014?

  I have 2 segments with respective min and max limits for a particular column B, whereas the table is partitioned on column A.   I gave a query with both A and B in the WHERE clause whose result-set is limited to only one of the two segments within the candidate partition, expecting Statistics IO to confirm one segment is skipped.  However, this was not the case.  I do not see SEGMENT SKIPPED message in Statistics.  Is there something wrong or is it that 2014 does not have Segment Skipped feature?

  thanks

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  August 19, 2019 at 10:10 am

  #3672228

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.