like ..i have got a query ..but its running out of time....i tried with many of mine friends..but i could not get the result
2006-07-09 23:45:43 · 2 answers · asked by Anonymous in Business & Finance ➔ Careers & Employment
is this on SQL Server ?
if so, what do you mean by "running out of time" ? It could be that the server is configured with a maximum query time which blocks queries running if the estimated times exceeds the configured limit
with oracle and sql server all queries are optimised automatically by the optimisation process so your query should already be optimised - do you have suitable indexes set up ?
without any other details its difficult to say but maybe you are using a subquery inefficiently or a cursor inappropriately
it is also (just) possible that the optimiser isn't optimising correctly in which case you will need to get into the exciting and complex world of hints
i need a lot more details to answer this effectively
2006-07-09 23:54:57 · answer #1 · answered by Ivanhoe Fats 6 · 0⤊ 0⤋
Use sq. question Analyzer it ought to come packaged with the server. you should use the question > tutor Execution Plan or Ctrl+alright to exhibit each and each and every of the places the position the database is hit and what number milliseconds each and each and every call is taking. it may help you spot the position the question is getting stuck. desire that facilitates.
2016-11-06 03:23:43 · answer #2 · answered by ? 3 · 0⤊ 0⤋