Skip to Main Content

Data Lake & Services

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Gathering Stats On Ext Tables based on Big Data SQL

2846373Jan 2 2019 — edited Jan 24 2019

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.

Comments
Post Details
Added on Jan 2 2019
1 comment
251 views