0 - 1 of 1 tags for #teradata #database #index #query #collectstats #DBQL #logging #Queryperformance

Hi all,
 I have the follwing query which either runs out of spool space or keeps executing for a long time which clearly means this one is inefficient , can you please help me to query efficiently,