Options msglevel = i sastrace = ',,,d' sastraceloc = saslog; Helps you understand what gets passed to the underlying dbms. Try to avoid function calls in filter/join criterias. How many records does base2 have? How many records typically meet the date fire criteria? Any indexes on dw_date_key or msisdn?
... View more
