Documentation for access plan for a SQL statement

[former_member461380]

Is there any documentation to describe the finer points of the explain portion in the display execution plan for SQL statement of ST04? I'm trying to learn how to use the explain part of the execution plan.

Thanks

Bruce

[lbreddemann]

Hi Bruce,

as understanding the explain plan is very different for each database, a good approach for you might be to check the quite good oracle documentation.

SAP just displays the information oracle provides. Therefore it's crucial to understand this first.

<a href="http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14211/toc.htm">Oracle® Database Performance Tuning Guide</a>

Furthermore there are plenty of books around that explain very detailed how to analyze what explain plan tell you. Look for books from Tom Kyte or Jonathan Lewis or whoever writes the way that pleases you.

KR Lars