Tarek Salha on 15 Jun 2017 19:04:59
Assume a data model with one fact table containing sales data and one dim table containing customers. If in direct query mode a filter concerning customer name is applied to a report page, then the resulting query which is sent to the SQL Server Backend contains a string predicate with that name. If the execution plan could send the associated ID instead, the resulting execution plan could take many advantages, especially in combination with clustered columnstore indexes (e.g. aggregate pushdown).
Is this possible?