I'm running my query from linked table from sage SALES_ORDER but it takes very long to show result. Even if I want to see only last 100 records or records from last 2 weeks. Is there any way to load and show results quicker ? Can anybody help me with this problem?
Thank you.