Submitted Questions

  • Cursor Advantages and Disadvantages

    What are the uses of Cursor? What are its advantage and disadvantage?

    Habib Ali

    • May 10th, 2016

    Advantage: Gets multiple-data inside the buffer cache, for faster DML operations

    Disadvantage: Consumes memory, has to be freed properly to avoid Buffer cache congestion

    WebSpider

    • Feb 11th, 2016

    Performance is reduced using cursor