I am running a normal insert-select query on a huge teradata table to populate another teradata table. There are 3 filter conditions in the where clause of which 2 are date field filters and the other is a integer field filter. Will there be any change in performance if the order of the filters are changed? The 2 date field filters are dominant and does huge filtering of records and the int field filter needs to filter from the records filtered by date fields. Let me know the impacts on various combinations of using these 3 fields as filter.
I understand you are trying out with just different filter condition sequence. but since you said bulk of filtering is done with dates, you can improve the query performance by defining a Partition on these date fields on your source table.