RE: Selecting fill factor (FILLFACTOR)

Deepak Why do you need to know? The fill factor is only taken into account when the index is first craeted, after that time the pages (including those from the initial build) are filled to capacity. A low fill factor (50-70) is useful if you know many entries are going to be inserted between the existing ones, otherwise best just left at the default (90). Keith -----Original Message----- From: Deepak.Patel@in.efunds.com [mailto:Deepak.Patel@in.efunds.com] Sent: 08 February 2005 12:51 To: informix-list@iiug.org Subject: Selecting fill factor (FILLFACTOR) How can I know the FILLFACTOR defined for a particular index from the system tables if user has created the index other than the specified FILLFACTOR in the onconfig file in a IDS 9.21 UC3 environment. Thanks Deepak ********************************************************************************** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ********************************************************************************** sending to informix-list