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 [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
