From: Becker, Holger (holger.beckersap.com)
Date: Fri Jul 04 2003 - 09:58:34 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Yusuf Gangat wrote:

> Can someone please explain to me how the EXPLAIN query works.
> I understand that it shows you which indexes will be used by the database optimizer.
> What I would like to know is the meaning of the: PAGECOUNT, O, D, T, M columns.
> Also, what does the last record RESULT IS COPIED , COSTVALUE IS indicate?
> How would I reduce the pagecount value for the RESULT IS COPIED , COSTVALUE IS strategy?
 
For general informatiom about explain statement have a look at
http://www.sapdb.org/7.4/htmhelp/6e/b4fe79e7d311d5995b00508b5d5211/frameset.htm

for O, D, T, M columns in detail here
http://www.sapdb.org/7.4/htmhelp/24/ff0788e97011d5995d00508b5d5211/frameset.htm

and the PAGECOUNT here
http://www.sapdb.org/7.4/htmhelp/40/13120c2fa511d3a98100a0c9449261/frameset.htm

For an explanation of the optimizer and how to increase performanc of you SQL have a look here
http://www.sapdb.org/7.4/htmhelp/fb/36fe3b34334a7be10000000a114084/frameset.htm

If you need more or detail information feel free to ask again.

Kind regards,
Holger
SAP Labs Berlin
_______________________________________________
sapdb.general mailing list
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]