Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Advantages and Disadvantages of Cursor?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is primary key and example?

894


Why is the need for data conversion transformations?

977


What are the differences between lost updates and uncommitted dependencies?

1010


How can we remove orphan records from a table?

929


Which is the main third-party tool used in sql server?

882


What is dbcc updateusage?

1150


What are SSL and TSL protocols?

931


Can foreign key be deleted?

870


Explain primary key, foreign key and unique key?

933


What are the types of resultset?

914


What is scrollable cursor?

983


What happens if null values are involved in arithmetic operations?

961


What is use of @@ spid in sql server?

1144


What is the difference between delete and truncate statements?

1016


Do you know what are acid properties of transaction?

908