In Teradata 12 SNOWFLAKE join queries not executing faster as compare to STAR join queries.This could be a fact across all databases but could not saw the issue in Teradata 6 but happening in Teradata 12. The question is, is there any way to change the DB setting to make Snowflake queries faster in Teradata 12?
Re: Teradata 12: Snowflake Vs Star query performance
It might not be star or snowflake which is the reason for the bad response. Check if the statistics are update and the collection is on right columns namely the columns participating in the join etc etc.