VARRAY (Varying Array) is the most performance-friendly collection type in Oracle because it's stored inline with the table data, has a fixed maximum size, and uses contiguous memory allocation. PL/SQL tables (associative arrays) and nested tables have more memory overhead.