And in many cases, filtering can also boost performance. Another new feature of NCS Indexes in SQL Server 2016 is the ability to apply filters to the index definition.