We have people running invoice printing jobs. The query on the database seems to be taking more than 10 minutes to run. The query seems to be spending the most time in a table scan on the SINVOICE table. Can I improve the performance by creating any index on SINVOICE or any other table? The problematic SQL is:
Can I improve the performance by creating any index