can anybody help me with this one
i want to delete rows from one table based values from another table.
here is the scenario
i have a table named custinfo which contain 2000000 records and a table custinfotemp which contain 30000 records. i want to delete all records in custinfo where the cust_id is found on custinfotemp where it's update status is 'D'
here is my sql statement
psql -h $HOSTNAME -d $DBNAME -c "DELETE FROM custinfo WHERE custinfo.UserID IN (SELECT custinfotemp.userid FROM custinfotemp where updateStatus='D')";
is it possible that this query statement takes 24 hours and still running to execute?
is there a way to achieve the same result faster?
thanks.