Basic question about Query Template in SAP MII

[aravinth_anandhan]

Hi All,

This is a basic question, but I want to confirm the answer from the experts.

If I write a SQL query in MII Query template, will the execution load goes to SQL server or in MII ?

Regards,

Aravinth

[former_member185280 · Accepted solution]

Well both sides have some work to do. Most of the load on the MII side would be it's part in shuttling the data coming back from SQL and formatting it for consumption within MII. SQL server does all of the work figuring out what data to return and then doing its part of shuttling the data back and forth.

Regards,
Christian