var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Large index - informix 9.4.
I have large table obout 1 milion rows - 80 GB.
Column name Type Nulls
id_name char(10) no
seria_name char(10) no
value integer no
For this table i have index:
create unique index i_table_AAAA on table_AAAA (id_name,seria_name) using btree
Table table_AAAA is not increased. But index i_table_AAAA after four-five days increased about 1 GB.
It is normal situation ??
How i can monitoring this index ??
Monitoring a table and its indexes can be done with:
An what happens with the index after issuing a
oncheck -pt database:table
UPDATE STATISTICS FOR TABLE table;
Last edited by Tyveleyn; 08-18-07 at 06:05.
force execute a b-tree check with onmode
i don't remember if this command works in 9.4 ...