Re: Different Query Paths

Luc Douwen writes: |At our site we encountered the following strange problem : |the same query launched from a PC client (inet) behaves differently as |that query launched from a server esqlc program. | |On the server a loin between two tables uses two times an index path. | |>From the PC one index path is replaced by a sequential scan. | |This means that same query uses 0.5 sec in the esqlc server program an |14 sec in the pc program. | |Is there anybody out there with suggestions ? I would suggest that you try upgrading the version of INET on the PC - we have seen similar things happening when we run an esql/c query from one engine version to another remote engine resulting in a different query path. Hope this helps, Richard Ridley