* added redundand join condition for index usage as per comment on CR r88008