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
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