Hi Guys
I'm a total noob and using 64 bit ODBC driver to query 10.2B SP06 (can't apply any other SP's as it's a 3rd party vendor product and that's the latest they certify) from SQL client (SSMS, RazorSQL, etc.).
Queries are really slow and I'm trying to figure out what the issue sis. Read loads of stuff about queryplan, but can't for life of me get it to work.
This is an example query:
Nothing I run against _Sql_Qplan returns any rows. From what I read, it should return the query plan for the last statement using this connection.
Anyone got any idea what I'm doing wrong? Does something need to be enabled first?
Regards
mark
I'm a total noob and using 64 bit ODBC driver to query 10.2B SP06 (can't apply any other SP's as it's a 3rd party vendor product and that's the latest they certify) from SQL client (SSMS, RazorSQL, etc.).
Queries are really slow and I'm trying to figure out what the issue sis. Read loads of stuff about queryplan, but can't for life of me get it to work.
This is an example query:
Code:
SELECT
Col1
FROM
PUB.apinvtrl
WHERE
"voucher-number" = ' 30889'
SELECT SUBSTRING("_Description",1,70) FROM pub."_Sql_Qplan" WHERE "_Pnumber" = (SELECT MAX( "_Pnumber" ) FROM pub."_Sql_Qplan" WHERE "_Ptype" > 0 )
Nothing I run against _Sql_Qplan returns any rows. From what I read, it should return the query plan for the last statement using this connection.
Anyone got any idea what I'm doing wrong? Does something need to be enabled first?
Regards
mark