How collections are improve the performance?
- 1 Answers
- 3815 Views
- Polaris, I also Faced
- E-Mail Answers
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
What are the different types of sql commands?
Can we use ddl statements in stored procedure?
How do you optimize a stored procedure query?
how to use regular expression in pattern match conditions? : Sql dba
How to read/write files from pl/sql?
Is inner join faster than left join?
What are the types of sql commands?
What is the process of copying data from table a to table b?
What is rollback?
How do you explain an index?
Is sql free?
What is t sql in sql server?
How do I find duplicates in the same column?
How can I tell if sql is running?
Is sql harder than python?
