Things to consider while working with SQL Script Procedures for CODE Pushdown?
Answer Posted / Pawan Kumar Kotarya
1. Minimize the use of dynamic SQL, as it can lead to performance issues and lack of code pushdown. n2. Avoid using complex business logic within procedures, keep them simple. n3. Consider using ABAP CDS views for complex queries instead of SQL Script Procedures, when possible. n4. Make sure to test the performance of your SQL Script Procedure with and without code pushdown to ensure improvement.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category