SYSMETAINDEX Value

source1Tamer · Post by **source1Tamer** » Tue Jul 23, 2002 10:09 am

what is the maximum amount of data in bytes(THRESH in SYSMETAINDEX table) could be specified?
I'm trying to disable the autoindex only on one table no matter how many bytes inserted/updated, by adding a very high Wait/THRSH for time/data size -respectivly-entry in the SYSMETAINDEX table.
To let u know, I've 4+ Geg of updates.

Post by **Kai** » Tue Jul 23, 2002 10:16 am

They're both long values, so the max would be 2GB on 32-bit systems and 2^63 (>9x10^18) on 64-bit Texis versions.

source1Tamer · Post by **source1Tamer** » Tue Jul 23, 2002 3:10 pm

so, in order to disable AutoIndexing for 15+ Gegs of changes (as a daily batch),
Should I disable the chkind for the whole system?(This will affect all other tables)..
Or, I have to turn chkind on, and Set SYSMETAINDEX to "1" and add entries only for tables that require autoindex in the SYSMETAINDEX table?

Post by **John** » Tue Jul 23, 2002 3:21 pm

Setting SYSMETAINDEX to 1 would be the better option, as it still lets chkind run where needed.