topic Difference between SQL Explain and SP Explain in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/difference-between-sql-explain-and-sp-explain/m-p/1618185#M276705 <HTML><HEAD></HEAD><BODY><P>What is the difference between SQL Explain and SP Explain? And why would they suggest a different index is being used for the same statement in the same trace?</P></BODY></HTML> Tue, 19 Sep 2006 23:21:50 GMT Former Member 2006-09-19T23:21:50Z Difference between SQL Explain and SP Explain https://community.sap.com/t5/application-development-and-automation-discussions/difference-between-sql-explain-and-sp-explain/m-p/1618185#M276705 <HTML><HEAD></HEAD><BODY><P>What is the difference between SQL Explain and SP Explain? And why would they suggest a different index is being used for the same statement in the same trace?</P></BODY></HTML> Tue, 19 Sep 2006 23:21:50 GMT https://community.sap.com/t5/application-development-and-automation-discussions/difference-between-sql-explain-and-sp-explain/m-p/1618185#M276705 Former Member 2006-09-19T23:21:50Z Re: Difference between SQL Explain and SP Explain https://community.sap.com/t5/application-development-and-automation-discussions/difference-between-sql-explain-and-sp-explain/m-p/1618186#M276706 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P> Go through the link,</P><P><A href="http://www.redbooks.ibm.com/redbooks/pdfs/sg247094.pdf#search=%22SQL%20Explain%20and%20SP%20Explain%20in%20SAP%22" target="test_blank">http://www.redbooks.ibm.com/redbooks/pdfs/sg247094.pdf#search=%22SQL%20Explain%20and%20SP%20Explain%20in%20SAP%22</A></P><P></P><P>Regards,</P><P>Azaz.</P></BODY></HTML> Tue, 19 Sep 2006 23:59:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/difference-between-sql-explain-and-sp-explain/m-p/1618186#M276706 Former Member 2006-09-19T23:59:22Z