Optimization of queries in SAP CPQ custom tables by script

[former_member817812]

Hi everyone

I have a problem with the query time to the SAP custom tables when performing them in the "Customized car calculations" scripts

• Is there a way to index CPQ custom tables and optimize scripted queries?
• What options do I have available to improve the query times to the custom CPQ tables by script when the records exceed one million?

Try to make your suggestions specific and feasible.

Thank you

[yogananda · Accepted solution]

alejandra_olivares

yes, If you feel there is slowness then you can ask support team to have one check on SQL query execution Plans for your custom table.. then you can provide index rebuild or to optimize ..

But its not recommened to store huge data in custom table.. its not best practice. Best approach : Maintain those records someplace at your side and expose the API for those data with filters options... so that you can use it through Ironpython scripting to call your destination RestAPI to pull or update.

[yogananda · Accepted solution]

alejandra_olivares

If this resolved, can you close the thread ?

[former_member817812 · Accepted solution]

Thanks for your contribution, it helped me a lot.