View parition elimination vs table performance

Database
Ambassador

Re: View parition elimination vs table performance

If you have known month ranges in your tables you must add WHERE-conditions matching those ranges in the view definition (If you use the recommended 1:1-view layer this would be the best place).

Or you change the partitioning constraint to match those ranges, removing not used MONTH_IDs (of course removing NO RANGE & UNKNOWN, too)

Teradata Employee

Re: View parition elimination vs table performance

OK Many Thanks!. I will test these suggestoins and get back.