Discuss about Disadvantages of cursors?

Discuss about Disadvantages of cursors?

Many disadvantages are in Cursor which is defined here :
> Occurs network round trip because Each time we fetch a row from the cursor,; where as a normal SELECT query makes only one round trip, however large the resultset is.
> It is very costly because they require more resources and temporary storage. Further, there are restrictions on the SELECT statements that can be used with some types of cursors.
> Another situation in which developers tend to use cursors: we need to call a stored procedure when a column in a particular row meets certain condition. We don\'t have to use cursors for this. This can be achieved using WHILE loop, as long as there is a unique key to identify each row.

Date:2014-01-09 00:00:00

Post Your Answers

User Email:

User Name:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher