Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 3 Tools : INDEXCHK

INDEXCHK
Estimates the maximum number of data rows a table can contain before reaching the maximum index levels. (E)
Invocation
Do one of the following:
On the Index Level Checking screen:
Usage Notes
If you want to sample existing data to estimate the average row length, you must have Level-7 security clearance.
For sequential inserts into a table or table instance with no secondary keys, INDEXCHK calculates the estimate assuming that all the tables pages (both data and indexes) are filled to their maximal value.
For random inserts, INDEXCHK calculates the estimate assuming that the top level of any index is filled to its maximal value and that all lower pages are sixty seven percent full. The result is only an estimate and may not correspond to the practical reality. Where a table is subject to random inserts and deletes, the estimate may be reduced further.
When secondary keys are defined, the estimate assumed that, even if the data is inserted in sequential order in regard to the primary key, the inserts are random in regard to any secondary keys. The secondary key providing the lowest number of rows is displayed.
Example
The following screen shows the result of invoking INDEXCHK:

 
                            Index Level Checking:
=====================
Application to estimate the Maximum # of Data Rows a table can
contain before Maximum Index levels are reached (PF1 for more details)
Table Name (must already be defined): INDEXCHK_DEMO
Average Data Row length : or Sample existing Data (Y/N): Y
#-Rows Sampled: 50000 Average Row Length: 41 #-Parms Sampled: 50
RESULTS:
Based on Sequential Inserts (giving maximal page utilisation)
Max Data Rows Limited by I-Index: 5,297,307,999,872
Max Data Rows Limited by S-Index: 3,001,948,715 (FIELD3)
Max Parameter Instances allowed : 66,999,227,038,614
Based on True Random Inserts
Max Data Rows Limited by I-Index: 741,305,536,999
Max Data Rows Limited by S-Index: 3,001,948,715 (FIELD3)
Max Parameter Instances allowed : 13,514,414,924,151
MSG:
ENTER=CALCULATE PF1=HELP PF3=EXIT

 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved