fillfactor stored in?
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 |
| Motorola, Inc. | rzbj40@email.sps.mot.com |
+----------------------------------------------------------------------------+