**TLDR:** does setting up a logical primary key on a named query in SSAS DSV (data source view) have any performance benefits and, if so, which?
---
Named queries in SSAS DSV don't necessarily need a logical primary key in order for the dimensions/measures to use them. The DSV named queries also don't need a relationship between them.
I have found that adding relationships doesn't have any performance benefits . So my question is the same for the logical primary key: does adding it have any perf benefits?
I was only able to find one article that mentions that adding a logical primary key does improve performance:
> In SSAS Data Source Views, logical primary keys and relationships are essential for data integrity and query performance
and
> Logical primary keys and relationships can help you improve the performance, accuracy, and usability of your SSAS solutions
However, they don't explain how does it impact the performance (i.e. do they somehow add an index on those columns or what-have-you).
Asked by PajLe
(133 rep)
Aug 5, 2024, 03:48 PM