Performance tuning query

[Yusuf Gangat]

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 [EMAIL PROTECTED]   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