Choosing the correct cursor type can improve application performance. Under certain conditions Microsoft® SQL Server™ may implicitly convert a cursor type if you execute an SQL statement not supported by the cursor type you requested.
Choosing a Cursor Type