After some investagtion with the DBA, we found that a bad query plan had been cached thus causing the slowness. Once we cleaned this up the query was running at around 30seconds.
Reply to this message by going to Community
Start a new discussion in Datasource Configuration at Community