Chris,
It just means that there isn't a dictionary item called POLICY, or at
least not one that is the same as it once was when the index was created.
It's probably looking for
DICT POLACCTRN_POSTED POLICY
01: D
02: 1
03: n/a
04: n/a
05: should have an L for left-justified
06: S
If you put something like the above back in the dictionary, suddenly
LIST.INDEX would say yes.
cds
On 5/5/2011 5:27 PM, Chris Austin wrote:
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.INDEXtable_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 BuildNulls In DICT S/M Just Unique Field num/I-type
POLICY DNot Reqd Yes NoSL N1
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
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users