From: Yusuf Gangat (yusuf.gangatpha.co.za)
Date: Fri Jul 04 2003 - 08:37:41 CDT

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

Hi
 
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?
 
Thanks in advance
 
Yusuf Gangat
Programmer
Tel : 031-2675000
Fax : 031-2675169
HYPERLINK "mailto:yusuf.gangatpha.co.za"yusuf.gangatpha.co.za
 
Disclaimer and confidentiality note
 
The information contained in this communication is confidential and may
be legally privileged. It is intended solely for the use of the
individual or entity to whom it is addressed and others authorised to
receive it. If you are not the intended recipient, you are hereby
notified that any disclosure, copying, distribution or taking action in
reliance of the contents of this information is strictly prohibited and
may be unlawful. Sweidan Trust is neither liable for the proper,
complete transmission of the information contained in this communication
nor any delay in its receipt.
 
 
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.493 / Virus Database: 292 - Release Date: 6/25/2003
 

_______________________________________________
sapdb.general mailing list
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general

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