Advantages and Disadvantages of Cursor?
Answers were Sorted based on User's Feedback
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 ? | 4 Yes | 0 No |
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 ? | 2 Yes | 0 No |
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 |
How to enter comments in transact-sql statements?
Can we linked SharePoint to a SQL database?
0 Answers Sans Pareil IT Services,
How to use transact-sql statements to access the database engine?
why cluster and non clusterindex are used in sqlserver 2000? explain with example
How do I perform an unattended install of sql server 2000?
How can I know what locks are running on which resource?
What is table join?
How do you delete duplicate records in sql server?
How can you append an identity column to a temporary table?
In what three ways is the return statement used in a stored procedure?
Explain about integration services of Microsoft SQL server?
How cand Optimize SQL Server Stored Procedures