Selecting fill factor (FILLFACTOR)
Posted in 2005
Topics: Server Administration, Versions, Editions & End-of-Life
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 electronic mail message is intended solely for the named recipients and may contain confidential and proprietary business information of eFunds Corporation and all its subsidiaries.If you are not a named recipient, please notify the sender immediately.You may not disclose the contents to any other person; use this electronic mail message or its contents for any other purpose; or further store or copy its contents in any medium. ***************************************************************************************** sending to informix-list
Deepak.Patel@in.efunds.com wrote: > 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. You cannot. It's not stored anywhere since it is only used at the time the index is created and then either the default FILLFACTOR or the specified one was used. Art S. Kagel