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
80523;
970-491-1244 FAX 970-491-1205 cwoodall@vth1.vth.colostate.edu
You can do anything with a computer, but you might not want to.
--
On Thu, 13 Jul 1995, Bob Baskett wrote:
} 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 |
} +----------------------------------------------------------------------------+
}