Skip to Content
Jun 07 at 07:18 AM

Plan viz analysis for cds view

36 Views Last edit Jun 07 at 02:53 PM 3 rev


1. I am facing a performance issue in cds view. To improve the performance we setup a flag in the initial cds view with zstatus = ' ' as where condition. We have total 60k records, in that zstatus was updated as 'X' for 5k records. So cds has to run for remaining 60k-5k = 55k records. If i remove the condition it is taking 55sec to execute, if i keep the condition it is taking 58sec to execute. It has to improve the performance right, why it is taking more time?.

2. I am trying to analyze cds view using plan viz analysis but i am not getting how to check the flow properly. Is there any document to explain this?