How to analyze statistics on all tables in a schema?
Posted: Thu Dec 01, 2016 8:01 pm
I am trying to analyze the stats on all tables in a schema. Is this possible using the analyze statistics function? I tried the following:
Code: Select all
dbadmin=> SELECT analyze_statistics('hippies');
ERROR 2065: analyze_statistics: Invalid table/projection/column hippies
dbadmin=> SELECT analyze_statistics('hippies.*');
ERROR 2065: analyze_statistics: Invalid table/projection/column hippies.*