James Qian Wang wrote: > 0|0|0|SCAN TABLE contact AS c USING COVERING INDEX elid2 > 0|1|1|SEARCH TABLE history AS h USING COVERING INDEX elid (elid=?)
There is no more efficient way to execute this query. > both very slow What file system? What disks? Any network? Regards, Clemens
