Cross R eference Index Problem (AREV Specific)
At 08 JAN 1999 12:58:09PM Rick Todd wrote:
I am using Advanced Revelations v3.12, NLM v1.5 on Novell network v4.11. I have one table that the cross reference indexes are not correct. When you search via a index, Example: "\" or "\=, the keys that are returned are incomplete and incorrect. In the past, to correct a problem such as this I would update or rebuild the index in question. This problem only occurs in one table in the database. The steps that I have taken currently.
1) Rebuilt the Index
2) Removed the Index and Recreated the Index.
3) Removed all Indexes, deleted the Bang (!) file and recreated all indexes.
If anyone has a suggestion I would really appreceitate it.
Thanks Rick
At 09 JAN 1999 10:56AM akaplan@sprezzatura.com - [url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url] wrote:
Try increasing the define dictionary length for the master key to about +5 the largest key.
akaplan@sprezzatura.com
At 10 JAN 1999 02:28PM Michael Slack wrote:
You might want to check that you aren't using the "\" as one of the indexing delimiters when you define the Crossreference index. If you are that might be your problem. Then you'd have to redefine the index and rebuild.
Michael Slack
At 02 FEB 1999 02:56PM Rick Todd wrote:
Are you referring to the Average Length of the dictionary?
At 03 FEB 1999 10:17AM akaplan@sprezzatura.com - [url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url] wrote:
No, the largest key.
So, if your keys are
1
10
100
1000
10000
the average length is 3, but the largest is 5. This means the master key should have a dictionary length of about 8.
akaplan@sprezzatura.com