S
steve pittman
Guest
Both "old style" joins (in WHERE) and "standards style" joins (ON clause) are fine, and produce the same query plan if the queries are logically equivalent. You describe the queries as being "parallel". Are the 2 queries from 2 threads in one process, or from 2 separate processes? You can get more insight into what is happening by turning on ODBC tracing, or by turning on OE sql server logging (SET PRO_SERVER LOG ON). For server logging, you would need access to the server machine to see the resulting logs. As mentioned in an earlier reply, more details (queries, maybe query plans) are needed to begin to understand what is happening. Don't forget that OE TechSupport is a resource to solve problems also! hope this helps, .....steve pittman
Continue reading...
Continue reading...