Improving the SELECT query performance on a large table in SQL Server (stackoverflow.com)stack
4 points by HOY in stackoverflow.com · 13y ago · stack
Q: How can I improve the performance of my queries ? Details: I have one table with 200k records (Sales) and one function getView_sls(@TON_orNPS) Below query takes 10-12 seconds SELECT * FROM Sales Below query takes 32-34 seconds SELECT * FROM getView_sls('TON') Below is my sale…