My Oracle Support Banner

PLSQL Collections Benefits and Performance (Doc ID 986423.1)

Last updated on SEPTEMBER 08, 2023

Applies to:

PL/SQL - Version 10.2.0.5 and later
Information in this document applies to any platform.

Purpose

The purpose of this document is to provide a quick reference to the Oracle PL/SQL Collections. This article provides details on when a particular collection type should be used, size limits, performance benefits and the difference between each of them.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Purpose
Questions and Answers
 Which collection type will have more benefits in terms of performance?
 What is the size limit of Nested Tables, Varrays and Associative arrays?
 Choosing a Collection Type
 Comparing Oracle Collection Types
 Ways of querying from the different types of collection.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.