READONLY hint on CURSOR

Alex_Caudron

Hi,

So SQL Prompt puts a hint to say that the cursor could (should?) be read only.  Honestly, this was the first time I heard a cursor could be made read only.  Is this a performance thing ?

Regards,

Alex

Tom_C

Hi Alex,

My understanding is that this is indeed suggested for performance.

A read-only cursor can only move forward through the result set and fetch rows, but it cannot modify the data, so circumstantially (depending on what you're trying to achieve) can help with performance on large result sets.