This guide cautions you against defining array fields with extents as part of your database definition, for a number of reasons. However, array variables, as well as array fields in temp-tables, can be very useful. One thing to keep in mind is that array element access is much faster than accessing an element of a list of comma-delimited strings. The example code in The CASE statement shows an example of this. The totals could have been accumulated within a single delimited list, but this would have involved scanning the list for the delimiters with each operation. The memory location of each element of an array is distinct and, therefore, quickly accessed.