I have stored procedure which takes more than a min to run in sql browser.when i call from java UI it times out.It has group by and order by clause.Should the group by have same number of columns as order by?? to fix.
You will have to share much more detailed information on the procedure, the data set, indices, preferably the actual execution plan(s) etc.
😎
Further,
- Are the same parameter values passed in those instances?
- Are the calls made from the same system?
- Are the calling systems on the same network?
- Are the result sets identical?