WRITE SOME DISADVANTAGE OF CURSOR?

Awadhendra Tiwari

Total Post:505

Points:2525
Posted by  Awadhendra Tiwari
 1541  View(s)
Ratings:
Rate this:
  1. Awadhendra Tiwari

    Post:505

    Points:2525
    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!