We have some external tables (on Exadata ) which are actually hive tables in our BDA environment and defined on BigDataSQL. Some tables can contain more than 800 millions rows.
We know that we should gather stats for those ext. tables in order to enable storage indexes on BDA. Then what is the fastest way to gather stats.
Thanks.