SQL Server Version - Columnstore - Segment elimination

  • etl2016

    Default port

    Points: 1455

    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: 80385

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

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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply