Optimising stored procedure
-
hi IS there any way to optimize a stored procedure for quick data retrival.. please help me thanks in advance..
pradip kishore
-
hi IS there any way to optimize a stored procedure for quick data retrival.. please help me thanks in advance..
pradip kishore
Yes, there is. Optimization with a stored procedure, like all other optimizations, is different for each procedure. Make sure you don't do anything unnessesary and that you don't pull the same information multiple times unless you have to. There might be some useful tools, try a google search on that.
The only way to speed up a Macintosh computer is at 9.8 m/sec/sec.
-
Yes, there is. Optimization with a stored procedure, like all other optimizations, is different for each procedure. Make sure you don't do anything unnessesary and that you don't pull the same information multiple times unless you have to. There might be some useful tools, try a google search on that.
The only way to speed up a Macintosh computer is at 9.8 m/sec/sec.
Dear Used Minimum,Temporary table, Minmum Joins, It will be optimize ur query