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.

Indexing is a critical part of database optimization. Indexing can dramatically increase query speed. However, DBAs still struggle with finding optimal indexes or optimal SQL plans. DBTA held a ...