RSA Scripts

Cursor LOCAL

cursor default is GLOBAL. use LOCAL FAST_FORWARD will execute much faster.

  1. Sql Server
  2. Tuning
  3. Advanced
  4. Vaknin Sammy

Last updated:

Warning: Review and test in a non-production environment before running.

Back to results

-- cursor default is GLOBAL. 
-- we use the next syntax to create a LOCAL cursor.
-- much much faster
declare c cursor LOCAL FAST_FORWARD
FOR SELECT NAME FROM TABLE;