Fetch command in cursor is very slow....

antonyrajeshi

Hi All,

I have a static cursor in my procedure and is running very slow.

actually its very fast to open the cursor but taking long time to fetch the each row.

Any ideas to improve the fetch command faster.

Regards
Antony

shash141183

Maybe you can try to see the matchcols for your query and try to improve/change the index if match cols is 0.

Fetch command in cursor is very slow....

re: Fetch command in cursor is very slow....

/bytes/development

/bytes/it

/bytes/about