How should we gather external table stats on bda via bigdata sql.
Summary
Gather stats for external tables.Content
Hello all;
We use bds for our external tables. We have daily jobs to ingest these tables on big data and nealry 200 tables. These tables are partitioned on hive. But, on oracle site, since there isn't any partition column, we should gather all statistic every day. It is taking too much time. Do you have any other method for this operation. Since we use these tables on oracle, Oracle should be able to know statistic information.
thank you.
2