https://community.sap.com/t5/application-development-and-automation-discussions/cds-views-usage-type-annotations-performance-impact/m-p/12509338#M2003885 <P>Hello,</P> <P>As i search through various forums and read through documents, I am getting mixed confirmation on whether below annotations have any CDS query performance impact or not:</P> <OL> <LI><STRONG>@ObjectModel.usageType.serviceQuality</STRONG></LI> <LI><STRONG>@ObjectModel.usageType.sizeCategory</STRONG></LI> <LI><STRONG>@ObjectModel.usageType.dataClass</STRONG></LI> </OL> <P>One view is that these annotations are there to describe characteristics of a CDS view and have no impact on CDS query performance. Other view is that many people seem to gain performance using these annotations.</P> <P>I am looking for a confirmed answer from some CDS view experts or SAP product team.</P> <P>Regards</P> <P>Gaurav</P> Thu, 14 Oct 2021 10:42:26 GMT GK817 2021-10-14T10:42:26Z https://community.sap.com/t5/application-development-and-automation-discussions/cds-views-usage-type-annotations-performance-impact/m-p/12509338#M2003885 <P>Hello,</P> <P>As i search through various forums and read through documents, I am getting mixed confirmation on whether below annotations have any CDS query performance impact or not:</P> <OL> <LI><STRONG>@ObjectModel.usageType.serviceQuality</STRONG></LI> <LI><STRONG>@ObjectModel.usageType.sizeCategory</STRONG></LI> <LI><STRONG>@ObjectModel.usageType.dataClass</STRONG></LI> </OL> <P>One view is that these annotations are there to describe characteristics of a CDS view and have no impact on CDS query performance. Other view is that many people seem to gain performance using these annotations.</P> <P>I am looking for a confirmed answer from some CDS view experts or SAP product team.</P> <P>Regards</P> <P>Gaurav</P> Thu, 14 Oct 2021 10:42:26 GMT https://community.sap.com/t5/application-development-and-automation-discussions/cds-views-usage-type-annotations-performance-impact/m-p/12509338#M2003885 GK817 2021-10-14T10:42:26Z https://community.sap.com/t5/application-development-and-automation-discussions/cds-views-usage-type-annotations-performance-impact/m-p/12509339#M2003886 <P>Hello,</P><P>I don't think that theses annotations have any performance impact. See comments of this blog post : <A href="https://blogs.sap.com/2020/02/06/cds-view-performance-annotation-for-cds-view-performance/#comment-546058">https://blogs.sap.com/2020/02/06/cds-view-performance-annotation-for-cds-view-performance/#comment-546058</A></P><P> from <SPAN class="mention-scrubbed">heiko.gerwens</SPAN>.</P> Mon, 10 Jan 2022 16:00:39 GMT https://community.sap.com/t5/application-development-and-automation-discussions/cds-views-usage-type-annotations-performance-impact/m-p/12509339#M2003886 Louis-Arnaud 2022-01-10T16:00:39Z