To All --
I have developed an application with about 30 tables and 30 sets. Some of the tables have about 10 indexes, but one of them has accumulated about 35 indexes. Occasionally, I am experiencing problems that I think are related to these indexes. I have several questions:
1. I understand that when a set is created by linking two tables together, Alpha creates an index. However, in control panel, when you choose a Set, Define Indexes, several other indexes also appear that were not created by the set. Where did these indexes come from? Are they all being used? How can you tell where they came from?
2. Some of the indexes are duplicates caused by the use of parenthises in one definition but not the other. eg: (A=.t. .or. B=.t.) vs. ((A=.t.).or.(B=.t.)). If you alter the extra parenthises to make the first match the second and rebuild all indexes, the duplicate index usually goes away. What is being altered here? Will whatever created the index originally make it come back?
3. If you delete the .cdx file for the table with 35 indexes, and click on rebuild all indexes, not all the indexes come back. Why not? If they previously were unnecessary, how can you know which ones to get rid of? Will they eventually come back?
Thanks to all for any help you can provide.
-- Dick James
I have developed an application with about 30 tables and 30 sets. Some of the tables have about 10 indexes, but one of them has accumulated about 35 indexes. Occasionally, I am experiencing problems that I think are related to these indexes. I have several questions:
1. I understand that when a set is created by linking two tables together, Alpha creates an index. However, in control panel, when you choose a Set, Define Indexes, several other indexes also appear that were not created by the set. Where did these indexes come from? Are they all being used? How can you tell where they came from?
2. Some of the indexes are duplicates caused by the use of parenthises in one definition but not the other. eg: (A=.t. .or. B=.t.) vs. ((A=.t.).or.(B=.t.)). If you alter the extra parenthises to make the first match the second and rebuild all indexes, the duplicate index usually goes away. What is being altered here? Will whatever created the index originally make it come back?
3. If you delete the .cdx file for the table with 35 indexes, and click on rebuild all indexes, not all the indexes come back. Why not? If they previously were unnecessary, how can you know which ones to get rid of? Will they eventually come back?
Thanks to all for any help you can provide.
-- Dick James
Comment