Query Manager - long running queries
My business partners have created a query via Query Manager. Unfortunately it runs about 6 minutes which causes their session of PeopleSoft to crash. Our DBA has looked at the query and re-written it via SQL Server. This executes directly against the database in a few seconds. Is there an easy way to get query manager query to use the DBA's SQL statement?
This is the Query Manager SQL:
SELECT A.OPEN_ITEM_KEY, A.OPEN_ITEM_STATUS, (CONVERT(CHAR(10),A.OPEN_DT,121)), (CONVERT(CHAR(10),A.CLOSED_DT,121)), (CONVERT(CHAR(10),A.JOURNAL_DATE,121)), A.JOURNAL_ID, A.JOURNAL_LINE, A.UNPOST_SEQ