• Post Reply Bookmark Topic Watch Topic
  • New Topic

Cursors - Which takes more time: OPEN or FETCH?

 
Chiranjib Bhattacharjee
Greenhorn
Posts: 12
Eclipse IDE Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I need to know which takes more time when dealing with cursors - OPEN or FETCH? I have tried finding it out on forums, but am unable to arrive at a definite answer.

Does OPEN actually fetch the data and place it in buffer cache or that is done during FETCH? And also, would it vary between databases - IBM DB2 and Oracle?
 
Don't sweat petty things, or pet sweaty things. But cuddle this tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!