Hi All,
UV9.6.1.16
HPUX 11
I have an index that is no longer working and am not sure why. The whole
purpose of this index is to allow me to use the SELECTINDEX to get a list of
items that have something in field 67 of the record. The index has 13 records
but there are actually 876 records with something in 67. I can rebuild the
index but I really want to know what went wrong.
Any thoughts would be appreciated.
The dictionary item looks like...
0001: I
0002: IF @RECORD<67> # '' THEN 1 ELSE ''
0003:
0004: Send^2532SAP
0005: 4R
0006: S
0007:
Here is the output from LIST.INDEX
LIST.INDEX MS_POH SIM.TRIGGER STATS
Alternate Key Index Statistics for file MS_POH
File........... MS_POH
Indices........ 1 (0 A-type, 0 C-type, 0 D-type, 1 I-type, 0 SQL, 0 S-type)
Index Updates.. Enabled, No updates pending
Index name Type Build Nulls In DICT S/M Just Unique Field num/I-type
SIM.TRIGGER I Not Reqd No Yes S R N IF @RECORD<67> #
'' THEN 1 ELSE
''
Statistics:
Number Records per Alternate Key Index Size
Index name of Keys Average Minimum Maximum StdDev (in Bytes)
SIM.TRIGGER 1 13 13 13 0 92
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
