DB Tips

select 'analyze table ' || tname || ' compute statistics;'
  from tab
 where tname not like 'TEMP%'
   and tname not like 'ITB%'

-- after analyze table

select table_name, num_rows, last_analyzed, avg_row_len from tabs;