Home > IT Answers > Development > HI GUYS – OPTIMIZATION
ASHISH77
0 pts.
 HI GUYS – OPTIMIZATION
Development, Lifecycle development
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..

Software/Hardware used:
ASKED: August 23, 2004  2:33 AM
UPDATED: August 23, 2004  10:23 AM
RELATED QUESTIONS
Answer Wiki:
Since you mentioned that you have a front end [program] to run this query, consider splitting your query into multiple queries using your front end to pass the results to the subsequent queries. It has been my experience that the smaller queries run faster. I've made the assumption that you already have appropriate indexes on each of your tables as well.
Last Wiki Answer Submitted:  August 23, 2004  10:23 am  by  MGaines   0 pts.
All Answer Wiki Contributors:  MGaines   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _