>Hi Naomi,
>
>Consider switching to a cdx (as much as possible or as you go along) with the next update. You can build the cdx and delete the idx's as a part of an update.exe The version of your app that you distribute in the update will contain the code with the changes to use the cdx where necessary. Only do a portion (those you absolutely need immediately) and perhaps you can do a gradual change through the next few updates to get as many switched over as possible.
>
Interestingly, with the CDX I have even worse results for this SQL than with IDX, though after first time the second select comes instanteniously. However, if I put sys(1104) between SQL calls, each of them takes almost 20 sec. With IDX it takes ~18 sec. So, with CDX I lost 2 sec. in performance.
In any case, it's too slow... There are 147234 records in the table with 0 deleted. SET DELETED is ON.
If it's not broken, fix it until it is.
My Blog