I am looking for answers to the same (or similar) question: Why cannot FileMaker make use of Oracle indexes when it can read and update Oracle tables? Did the developers finish the ESS job halfway through, or is there an obstacle to this outside FileMaker/ESS?
We are trying to use FileMaker as client with Oracle server (and would be happy not having to redo all the work done in Oracle already). But not making use of Oracle indexes leaves us with the option to import the whole thing into FileMaker to make it respond in time. Not what we wished for.
(The article http://www.filemaker-solutions.be/IMG/pdf/techbrief_ess_en.pdf certainly states that FileMaker ESS functionality has no access to the ESS indexes whatsoever, but gives no explanation for this - only advice of how to avoid time-consuming actions in this environment. The article was written while FileMaker 9 was the current version. Nothing improved since then?)