FILL FACTOR

Posted in 2008

Neil Truby — Sat, 5 Jan 2008 10:37:47 -0000 — source: Usenet: comp.databases.informix

Having spent about half an hour looking for a CREATE INDEX example showing show to use the FILLFACTOR option I now can't find how to display the current fill factor for an index! Does anyone know please? Thx Neil

↪ replying to Neil Truby

Obnoxio The Clown — Sat, 05 Jan 2008 10:45:07 +0000 — source: Usenet: comp.databases.informix

Neil Truby wrote: > Having spent about half an hour looking for a CREATE INDEX example showing > show to use the FILLFACTOR option I now can't find how to display the > current fill factor for an index! > > Does anyone know please? > dbschema -ss? Just a guess. -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

↪ replying to Obnoxio The Clown

Neil Truby — Sat, 5 Jan 2008 10:53:42 -0000 — source: Usenet: comp.databases.informix

"Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:mailman.208.1199529805.20610.informix-list@iiug.org... > Neil Truby wrote: >> Having spent about half an hour looking for a CREATE INDEX example >> showing show to use the FILLFACTOR option I now can't find how to display >> the current fill factor for an index! >> >> Does anyone know please? >> > > dbschema -ss? Just a guess. Doesn't seem to: dbaccess caps < pres_event_group_a_build.sql Database selected. Index created. Index created. Index created. Database closed. $ cat pres_event_group_a_build.sqlcreate index "caps".i_preseventgroupa1 on "caps".pres_event_group_a (peg_serial,pga_serial) using btree fillfactor 70 in capsdbs ; create index "caps".i_preseventgroupa2 on "caps".pres_event_group_a (peg_org_code,peg_date,peg_type,peg_start_time30,pga_serial) using btree fillfactor 70 in capsdbs ; create index "caps".i_preseventgroupa3 on "caps".pres_event_group_a (pga_datetime) using btree fillfactor 70 in capsdbs ; dbschema -d caps -t pres_event_group_a -ss DBSCHEMA Schema Utility INFORMIX-SQL Version 10.00.FC4W3 Copyright IBM Corporation 1996, 2004 All rights reserved Software Serial Number AAA#B000000 { TABLE "caps".pres_event_group_a row size = 146 number of columns = 17 index size = 62 } create table "caps".pres_event_group_a ( pga_serial serial not null , ..... create index "caps".i_preseventgroupa1 on "caps".pres_event_group_a (peg_serial,pga_serial) using btree in capsdbs ; create index "caps".i_preseventgroupa2 on "caps".pres_event_group_a (peg_org_code,peg_date,peg_type,peg_start_time30,pga_serial) using btree in capsdbs ; create index "caps".i_preseventgroupa3 on "caps".pres_event_group_a (pga_datetime) using btree in capsdbs ;