Can anyone tell me a little more about the execution plan. I am a little
confused by the explanation on the SDK. I was analyzing the execution plan
option to find out ways to speed up my queries which use cursors. The
queries are being generated of tables that are properly indexed but the
actual execution is taking a significant amount of time as there is a lot of
processing that is being done on the server end.
Can anyone give me any ideas in general as to how to speed the queries up. A
brief idea about the query.
Select info. into a cursor
for each item in the cursor
perform a select
perform multiple computations into temp variables
perform updates on tables
Can anyone give me some idea about what other constructs other than cursors
can be used that allows processing in a loop and not use as much overhead?
Can anything be done on the DB administration level that speeds this query