I recently noticed that one of our tables is taking forever to return a simple
SELECT statement. Upon further review I noticed
1 difference between the tables that run fast and the slow table. That
difference is noticed when you type LIST.INDEX <table_name>.
File........... POLACCTRN_POSTED
Indices........ 1 (0 A-type, 0 C-type, 1 D-type, 0 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
POLICY D Not Reqd Yes No S L N 1
As you can see above 'In DICT' is set to NO. However on the same table on a
different
server it's set to 'yes'. Any idea how to add this value to the dictionary? I
looked up
In DICT in the reference manual and all it said was:
In DICT
Yes File dictionary contains corresponding field
No File dictionary does not contain corresponding field
So based on what it's saying, the dictionary doesn't contain the corresponding
field. Any help is appreciate, thanks.
Chris
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
