Can we use CASE in CREATE JOIN INDEX

UDA

Can we use CASE in CREATE JOIN INDEX


Hi,

I am trying to create AGGREGATE JOIN INDEX with CASE expression in select and group by clause and its throwing an error.
what should be the work around for this issues?
I am using Teradata 12 version.

Thank you,
Chakri.
1 REPLY
Enthusiast

Re: Can we use CASE in CREATE JOIN INDEX

Can you share your SQL?