When is it recommended to collect stats on the tables ? Does it help in query performance ?
@vrb Collecting stats is to help with better rowcount estimates for scans, if your scans are reporting completely off values. Check your job profile-planning tab-see rowcount for PARQUET/HIVE scans and see how close they are to the actuals