Community

SQL Server 2016 ColumnStore Index String Predicate Pushdown

(Ahmad Yaseen) When designing a data warehouse, it is recommended to use numeric or integer keys to filter records or in the join operator predicates, rather than using string columns. Applying these predicates on string values is very expensive and will significantly slow down your analytical quer

Read More - Register for Free Membership