What is a “large” select list?

A question came up in CDP about what a “large” dynamic array is, when used as a select list, and when lists should be processed as dimensioned arrays versus dynamic arrays. The answer can be more complex than one might think.