Teradata 12: Snowflake Vs Star query performance

UDA

Teradata 12: Snowflake Vs Star query performance

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?
2 REPLIES
Enthusiast

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.
Teradata Employee

Re: Teradata 12: Snowflake Vs Star query performance

Also make sure to define Referential Integrity between the PK and FK columns.

I usually recommend "Soft RI," with the "NO CHECK" option.

jdg