Re: Fragmentation on SAN Environment (cooked file

Just copy the justifications in the Performance Guide. The most important, in brief: - Parallel scanning of multiple dbspaces - Fragment elimination reduces the number of rows that need to be scanned Art S. Kagel ----- Original Message ----- From: Sunil Thakkar <ids@iiug.org> At: 2/16 12:16 All, (Sorry about the previous mime format email - I will try it once again.) I did a load of table that use to take 4 hours (20 m rows - with 2 text fields). After fragmentation with no change in anything else (divided into 20 dbspaces) the load took only 52 min. But I am not able to convince my boss that fragmentation is helping him. He wants more justification to implement fragmentation. We are using Informix 7.31 using SAN and Cooked File for the cunks (NO RAW devices - don't ask me why) Can someone guide me as to where will I find documented benefits of using Fragmentation under SAN disk environment. I am not giving too much details about the environment etc as it would be too much of unwanted information for this topic. Thanks, Sunil Thakkar. ******************************************************************************** ******************* The information in this email is confidential and may be legally privileged. Access to this email by anyone other than the intended addressee is unauthorized. If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you are not the intended recipient, please reply to or forward a copy of this message to the sender and delete the message, any attachments, and any copies thereof from your system. ******************************************************************************** ******************* ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.