>I'm working with an application where they author of the app is using only free tables, and idx vs cdx indexes. I understand all the issues with the free tables and not having them in a DBC -- but I've never even used IDX indexes. I'm wondering if there are any advantages or disadvantages to using IDX indexes. Thanks!
Hi Victor:
I use IDX indexes from time to time in special cases.
In example, if you need to use a non-existent index for a process and do not want to add it to the existent CDX, then the best you can do is generating a compact-IDX that you can delete later.
On the other hand, if you want to use more than one non-existent indexes, then you can create a temporal CDX (using "OF cdx"), but I didn't test this in particular.
I've found 2 use-cases for this:
1) When you do not want to touch the existent indexes and want to use your own.
2) When the order you want is rarely used, and do not want to add it to the existent ones that are updated all the time (consuming resources and time)
Best Regards.-
Fernando D. Bozzo
Madrid / Spain