fillfactor stored in?

fillfactor stored in?

Post by Bob Baske » Fri, 14 Jul 1995 04:00:00



when you create an index and specify a fillfactor, where is that information
stored?  also, i created the following table :

create table "baskett".hibob
  (
    c1 char(1),
    c2 integer
  ) extent size 16 next size 16 lock mode page;
revoke all on "baskett".hibob from "public";

create index "baskett".hibob1 on "baskett".hibob (c1) fillfactor 90;

and ran dbschema -ss -d testing -t hibob and got the following output:

(h2001)/bsi/users/baskett>dbschema -ss -d testing -t hibob

DBSCHEMA Schema Utility       INFORMIX-SQL Version 7.10.UC1  
Copyright (C) Informix Software, Inc., 1984-1994
Software Serial Number AAA#J830085
{ TABLE "baskett".hibob row size = 5 number of columns = 2 index size = 7 }
create table "baskett".hibob
  (
    c1 char(1),
    c2 integer
  ) extent size 16 next size 16 lock mode page;
revoke all on "baskett".hibob from "public";

create index "baskett".hibob1 on "baskett".hibob (c1);

it doesnt show the fillfactor! any help would be appreciated.

--
regards,
+----------------------------------------------------------------------------+
|     .     .     | Bob Baskett                                              |
|    ...   ...    | Software Engineer                                        |
|   ..... .....   | Business Systems Integration Group                       |
|  ..   ...   ..  | Semiconductor Products Sector                            |
| .      .      . | Mesa, AZ                                                 |
|                 | President, Informix Users Group Of Arizona               |

+----------------------------------------------------------------------------+

 
 
 

fillfactor stored in?

Post by Con Wooda » Tue, 18 Jul 1995 04:00:00


Fillfactor refers to the density of entries within index pages and is only
effective at index creation or re-creation.  the pages will then populate
according to index values so there seems to be no need to retain the fill
factor.

Good Luck

--
Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; Ft. Collins CO 80523;

You can do anything with a computer, but you might not want to.
--


} when you create an index and specify a fillfactor, where is that information
} stored?  also, i created the following table :
}
} create table "baskett".hibob
}   (
}     c1 char(1),
}     c2 integer
}   ) extent size 16 next size 16 lock mode page;
} revoke all on "baskett".hibob from "public";
}
} create index "baskett".hibob1 on "baskett".hibob (c1) fillfactor 90;
}
} and ran dbschema -ss -d testing -t hibob and got the following output:
}
} (h2001)/bsi/users/baskett>dbschema -ss -d testing -t hibob
}
} DBSCHEMA Schema Utility       INFORMIX-SQL Version 7.10.UC1  
} Copyright (C) Informix Software, Inc., 1984-1994
} Software Serial Number AAA#J830085
} { TABLE "baskett".hibob row size = 5 number of columns = 2 index size = 7 }
} create table "baskett".hibob
}   (
}     c1 char(1),
}     c2 integer
}   ) extent size 16 next size 16 lock mode page;
} revoke all on "baskett".hibob from "public";
}
} create index "baskett".hibob1 on "baskett".hibob (c1);
}
} it doesnt show the fillfactor! any help would be appreciated.
}
} --
} regards,
} +----------------------------------------------------------------------------+
} |     .     .     | Bob Baskett                                              |
} |    ...   ...    | Software Engineer                                        |
} |   ..... .....   | Business Systems Integration Group                       |
} |  ..   ...   ..  | Semiconductor Products Sector                            |
} | .      .      . | Mesa, AZ                                                 |
} |                 | President, Informix Users Group Of Arizona               |

} +----------------------------------------------------------------------------+
}


 
 
 

fillfactor stored in?

Post by Con Wooda » Tue, 18 Jul 1995 04:00:00


Fillfactor refers to the density of entries within index pages and is only
effective at index creation or re-creation.  the pages will then populate
according to index values so there seems to be no need to retain the fill
factor.

Good Luck

--
Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; Ft. Collins CO
80523;

You can do anything with a computer, but you might not want to.
--


} when you create an index and specify a fillfactor, where is that information
} stored?  also, i created the following table :
}
} create table "baskett".hibob
}   (
}     c1 char(1),
}     c2 integer
}   ) extent size 16 next size 16 lock mode page;
} revoke all on "baskett".hibob from "public";
}
} create index "baskett".hibob1 on "baskett".hibob (c1) fillfactor 90;
}
} and ran dbschema -ss -d testing -t hibob and got the following output:
}
} (h2001)/bsi/users/baskett>dbschema -ss -d testing -t hibob
}
} DBSCHEMA Schema Utility       INFORMIX-SQL Version 7.10.UC1  
} Copyright (C) Informix Software, Inc., 1984-1994
} Software Serial Number AAA#J830085
} { TABLE "baskett".hibob row size = 5 number of columns = 2 index size = 7 }
} create table "baskett".hibob
}   (
}     c1 char(1),
}     c2 integer
}   ) extent size 16 next size 16 lock mode page;
} revoke all on "baskett".hibob from "public";
}
} create index "baskett".hibob1 on "baskett".hibob (c1);
}
} it doesnt show the fillfactor! any help would be appreciated.
}
} --
} regards,
} +----------------------------------------------------------------------------+
} |     .     .     | Bob Baskett                                              |
} |    ...   ...    | Software Engineer                                        |
} |   ..... .....   | Business Systems Integration Group                       |
} |  ..   ...   ..  | Semiconductor Products Sector                            |
} | .      .      . | Mesa, AZ                                                 |
} |                 | President, Informix Users Group Of Arizona               |

} +----------------------------------------------------------------------------+
}

 
 
 

fillfactor stored in?

Post by Con Wooda » Tue, 18 Jul 1995 04:00:00


Fillfactor refers to the density of entries within index pages and is only
effective at index creation or re-creation.  the pages will then populate
according to index values so there seems to be no need to retain the fill
factor.

Good Luck

--
Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; Ft. Collins CO
80523;

You can do anything with a computer, but you might not want to.
--


} when you create an index and specify a fillfactor, where is that information
} stored?  also, i created the following table :
}
} create table "baskett".hibob
}   (
}     c1 char(1),
}     c2 integer
}   ) extent size 16 next size 16 lock mode page;
} revoke all on "baskett".hibob from "public";
}
} create index "baskett".hibob1 on "baskett".hibob (c1) fillfactor 90;
}
} and ran dbschema -ss -d testing -t hibob and got the following output:
}
} (h2001)/bsi/users/baskett>dbschema -ss -d testing -t hibob
}
} DBSCHEMA Schema Utility       INFORMIX-SQL Version 7.10.UC1  
} Copyright (C) Informix Software, Inc., 1984-1994
} Software Serial Number AAA#J830085
} { TABLE "baskett".hibob row size = 5 number of columns = 2 index size = 7 }
} create table "baskett".hibob
}   (
}     c1 char(1),
}     c2 integer
}   ) extent size 16 next size 16 lock mode page;
} revoke all on "baskett".hibob from "public";
}
} create index "baskett".hibob1 on "baskett".hibob (c1);
}
} it doesnt show the fillfactor! any help would be appreciated.
}
} --
} regards,
} +----------------------------------------------------------------------------+
} |     .     .     | Bob Baskett                                              |
} |    ...   ...    | Software Engineer                                        |
} |   ..... .....   | Business Systems Integration Group                       |
} |  ..   ...   ..  | Semiconductor Products Sector                            |
} | .      .      . | Mesa, AZ                                                 |
} |                 | President, Informix Users Group Of Arizona               |

} +----------------------------------------------------------------------------+
}

 
 
 

fillfactor stored in?

Post by Jim Gord » Tue, 18 Jul 1995 04:00:00



Quote:> Subject: Re: fillfactor stored in?
> Fillfactor refers to the density of entries within index pages and is only
> effective at index creation or re-creation.  the pages will then populate
> according to index values so there seems to be no need to retain the fill
> factor.

> Good Luck

> --
> Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; Ft. Collins CO

Sorry Con but what about when you want to reload the database using
dbexport/dbimport and have it start out with the original fillfactor values?

Personally I am saddened to see that Informix made this mistake again. We only
just got the first extent, next extent info into dbexport.  It looks as if the
problem is worse this time as the fillfactor doesn't appear to be in the system
tables which means that we cannot even write scripts to extract the information
and parse it into the dbimport script.

Cheers - Jim

--
-----------------------------------------------------------------------------

-----------------------------------------------------------------------------
My opinions are my own.  They may vary with time but they remain mine!

 
 
 

1. Where are FillFactors stored in system tables?

Once you create an index with a fill factor, where does Informix store
it in the data dictionary?

For example, I would like to get a list of all the indexes with Fill Factors
less that 90.

Any help would be greatly appreciated. Thanks!


2. Problems Generating Forms with Designer2000

3. clustered index/fillfactor/new table

4. transactional / queued

5. FILLFACTOR (SCAN DENSITY VS. AVERAGE PAGE DENSITY)

6. change owner of all objects

7. Fillfactor

8. Error when calling the Fill method

9. index fillfactor

10. FILLFACTOR in clustered index

11. fillfactor question

12. DBREINDEX Fillfactor Question

13. FillFactor