Add ignore table drop param, query performance fixes, delete legacy transient