SAP Community
About shreyas_mehta
shreyas_mehta
Employee
Member since
2022 Sep 01
User Statistics
2
Posts
0
Solutions
0
Kudos given
0
Kudos received
View all badges
Options
Report User
User Activity
Posts
Replies
Docstore Collection table join is making the query execution extremely slow
2022 Nov 15
Team, We have 2 Docstore/Collection tables. We need to join them and get appropriate data. We are facing following performance issues : 1. We need to create respective views as direct joining of these Docstores/collections is not allowed. 2. Wi...
Re: Docstore Collection table join is making the query execution extremely slow
2022 Nov 15
Sample query : WITH ATS AS( SELECT "_id" AS "scenarioInstanceId" FROM "DOCSTORE_SC_IN" )SELECT AVG ( TO_DOUBLE("STEPS"."STPCT") ) AS "SC_Step_Cycle_Time"FROM ATSINNER JOIN "ADHOC_VIEW_STEPSVIEW" AS STEPSON STEPS."SIID" = ...
