I need help thinking this through. One of our clients just need data for specific PCS numbers we have. There are about 84,000 records. All I was trying to do is a simple query to get the data.
Select* from pcs
where pcs_id IN (whatever 84,000 ids are)
I got this error....This timed out and said it was using too much resources.
Then I tried to do an insert statement into an actual table I was creating. That did not work either, I got the same error.
What Can I do to prevent this from happening. This is a one time extract.
Thanks in Advance.