I'm using OpenEdge 10.2A with 64 bit ODBC driver and linked server in SQL Server 2008 R2
I run a SQL query that spans 5 tables (probabaly a few thousand rows in each and all inner joins). Query completes in 15 secs (need to improve, but it will do for now).
If I mis-spell ONE column name, it takes 2min 40secs before I get a message saying .
Anyone got any idea why?
Also, is there something I can use in Progress (total noob) to see the execution plan that was generated so I can tune the queries?
Thanks
Mark
I run a SQL query that spans 5 tables (probabaly a few thousand rows in each and all inner joins). Query completes in 15 secs (need to improve, but it will do for now).
If I mis-spell ONE column name, it takes 2min 40secs before I get a message saying .
Anyone got any idea why?
Also, is there something I can use in Progress (total noob) to see the execution plan that was generated so I can tune the queries?
Thanks
Mark