I need to check for the existence of at least one record in an entity with filters. Is it cheaper to do a $Count = true or $Top = 1? I know in SQL, a TOP would be cheaper but wasn't sure if SQL is being queried under the covers.
Yes, there is a SQL database behind the scene. F&O OData service exposes data entities. And data entities are implemented as views in SQL database (plus extra logic in the application layer).
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
245
Share
Report
All responses (
Answers (
