From one day to the other the SQL script became very slow executed via DB Query Reader in KNIME.
When I executed the same script in SQL Server MS it returns the results within no time. The returned table contains only 1-2 rows.
I did not changed anything in the script so I do not know how to find the rootcause for such degradation in execution time.
Do you have any idea what to check in KNIME?