Hello,
I have seen several posts about but nothing has quite given the answer that I have been looking for so here I am starting my own thread.
We currently have a database on SQL Server 2005 which is used as our warehouse for a database on a HP-UX machine running progress 9.1e.
If i run an openquery I am getting very poor execution times when returning results.
An example query follows as:
SELECT * FROM OPENQUERY (<server>, 'Select Post_id from pub.post')
It takes in excess of 20 minutes to return 679,000 rows which seems to be extremely slow.
There is an index on that column in the progress database from what I can see called Post_id. Is there a way I can get the query to utilise the indexes so that I can reduce the time it takes to return the results? if so could example syntax please be supplied?
My knowledge of Progress is extremely limited as the product is supplied by a 3rd party. Could the slow execution times be down to certain maintenance not being run?
I have seen several posts about but nothing has quite given the answer that I have been looking for so here I am starting my own thread.
We currently have a database on SQL Server 2005 which is used as our warehouse for a database on a HP-UX machine running progress 9.1e.
If i run an openquery I am getting very poor execution times when returning results.
An example query follows as:
SELECT * FROM OPENQUERY (<server>, 'Select Post_id from pub.post')
It takes in excess of 20 minutes to return 679,000 rows which seems to be extremely slow.
There is an index on that column in the progress database from what I can see called Post_id. Is there a way I can get the query to utilise the indexes so that I can reduce the time it takes to return the results? if so could example syntax please be supplied?
My knowledge of Progress is extremely limited as the product is supplied by a 3rd party. Could the slow execution times be down to certain maintenance not being run?