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...

How collections are improve the performance?

Answer Posted / kesava

COLLECTION:
Collection contains number of user defined types which is
stored number of data items in Single unit.
Why introduce Collection:
--->When ever we are using cursor memory area control does not get it back from Active set Area.
=====>when ever we are using Collection we are operating
element and also we are moving forward and reverse directions with in memory are using Collection
collection Types:
index by Table
Nested Table
Varray

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data type in sql?

1006


What are different categories of sql commands?

1195


Does group by remove duplicates?

1092


Does truncate require commit?

1033


How sql query is executed?

1187


What is a stored procedure in sql with example?

1202


What does an inner join do?

1248


What is string data type in sql?

1216


Why primary key is required?

1044


What is the use of <> sql?

1038


Is delete faster than truncate?

1052


List the various privileges that a user can grant to another user?

1092


What is rename command in sql?

1093


What are the different types of triggers?

1192


I need a function for a train ticket reservation please answer it thanks in advance

1078