Im setting up a new DB connect. While creating inputs i could execute the SQL query and get results in Batch Mode. Where as when i execute the same query in Rising Column mode (which adds Order by clause to the query) takes more time and i get query time out message.
I suspect this is because the initial query pulls entire records which is around 13 Million records
Please suggest if there is any alternate method?
Query im using :
Select * from table_name where column_name1 LIKE %abc% AND column_name2 > ? ORDER BY column_name2 ASC