RE: Get max length of data for a column

>> 'select '''||table_name||'.'||column_name||''', max(length('||column_name||')) from '||table_name||';'

Good Idea... combined with my suggestion, you'd only be dynamically looping for each table instead of each table/column.  That would certainly decrease that part of the overhead.

Additionally, since it'd only be a single full table scan that would decrease the number of full table scans.  However, the trade off is increased memory usage per query as every column would be needed rather than just the specific column you need so there's a hit to consider there.

Roger


________________________________
This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply.