nolock option it good for reading data.

pls create index on ORDER_DATE,COMMIT_NO column

after that pls excute below code.

select * from

(SELECT *,ORDER_DATE+COMMIT_NO new_id

FROM TABLE A (NOLOCK))k

WHERE new_id

NOT IN

(SELECT ORDER_DATE+COMMIT_NO

FROM TABLE1 B(NOLOCK)

WHERE ORDER_DATE >= A.LAST_ORDER_DATE)