WRITE SOME DISADVANTAGE OF CURSOR?

Awadhendra Tiwari

Total Post:510

Points:2550
Posted by  Awadhendra Tiwari
 1414  View(s)
Ratings:
Rate this:
  1. Awadhendra Tiwari

    Post:510

    Points:2550
    Write some disadvantage of Cursor?

    Cursor plays there row quite nicely but although there are some disadvantage of Cursor .
    Because we know cursor doing roundtrip it will make network line busy and also make time consuming methods. First of all select query gernate output and after that cursor goes one by one so roundtrip happen.Another disadvange of cursor are ther are too costly because they require lot of resources and temporary storage so network is quite busy.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!