• I am using all these index fields in a WHERE condition. I am using this table for a data conversion purposes. So, I need to search all these fields for invalid records for destination table. Is it recommend to use covering index (Ex : WORKADDR1 + WORKADDR2 + WORKADDR3 + WORKADDR4 ) even though I want to search each fields individually.

    - Zahran -