is there any stored procedure optimization techniques
actually my problem is
my stored procedure is getting information from 15 tables by joins and have some conditions in where clause
to get 15,000 records it is taking 40 sec
how can i improve the my stored procedure
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!