Advantages and Disadvantages of Cursor?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / vinod

15 Answers
100193 Views
Polytechnic, TCS, Zenith, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Advantages and Disadvantages of Cursor?..

Answer / vivekanand

Merits: Row by Row Validations, good choice for small set of records

De-Merits: it Increases Network Traffic, result to slowdown the Speed and Performance of the Database,
Consumes More Resources, bad choice for large set of records.

Cheers,Vivekanand

Is This Answer Correct ?

5 Yes

0 No

Advantages and Disadvantages of Cursor?..

Answer / sandeep singh

Advantages:
Cursors are somewhat like Pointers of Oracle, Oracle executes a query and assign some name to that memory location, which is known as Cursor.
Cursors are used for storing data temperarorily.
Cursors are used for storing, managing and retrieving data.
Cursors stores in the RAM so the data access and retrieval is fast.

Disadvantage:
No such disadvantage. Only thing is that rather than storing data in an intermediate variable and fetching it one by one via cursor and then processing it sequentially, we can use Collections. By using collections, we can pass the bundle of Data at once.

Is This Answer Correct ?

3 Yes

0 No

Advantages and Disadvantages of Cursor?..

Answer / reddi

to handle to many rows.

Is This Answer Correct ?

1 Yes

1 No

Advantages and Disadvantages of Cursor?..

Answer / nageswara rao

as per my Knowledge cursor is data type which is used to
define multivalue variable.if u take int a ,here a is
static variable which hold only one value at a time.in some
situvations we need data type variable which hold
multivalues

if any one find new answer ,send me
nag.mca08@gmail.com

Is This Answer Correct ?

28 Yes

89 No

Advantages and Disadvantages of Cursor?..

Answer / nnnnhgg

no disadvantahes

Is This Answer Correct ?

9 Yes

88 No

Post New Answer