Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Difference between SQL Explain and SP Explain

Former Member

‎2006 Sep 20 12:21 AM

0 Likes
429

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?

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?

Reply
1 REPLY 1
Read only

Former Member

‎2006 Sep 20 12:59 AM

0 Likes
376

Hi,

Go through the link,

http://www.redbooks.ibm.com/redbooks/pdfs/sg247094.pdf#search=%22SQL%20Explain%20and%20SP%20Explain%...

Regards,

Azaz.