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 are the disadvantages of mysql? : Sql dba

1131


What is the usage of when clause in trigger?

1032


What is sqlservr exe?

964


How do you create a db file?

997


How do you identify a primary key?

1047


What is nosql db?

954


What is a sql trace file?

1011


What do you mean by query optimization?

984


What is the source code of a program?

1046


How many joins in sql?

982


Can we insert data into materialized view?

931


How long does it take to learn pl sql?

1044


What is pl sql in dbms?

934


How to Execute a Package in PL/SQL.?

1184


What is audit logout in sql profiler?

1006