I HAVE A SQL QUERY WITH 6 TO 7 TABLES IN IT WITH ALL THE RELAVANT JOINS.. WHEN I RUN THIS QUERY IN SQL + , IT TAKES AROUND 3 MIN. TO SHOW ME 3 ROWS AND WHEN THIS QUERY IS RUNNED IN FRONT END , IT SHOWS "OPERATION TIME OUT"
CAN U PL.TELL ME HOW TO OPTIMIZE THIS QUERY AND IS SEQUENCE OF COLUMNS IN WHERE CLAUSE EFFECT THE OPTIMIZATION PARAMETERS..
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!