Re: Very Slow Process problem.
Abbhay,
If at all possible, turn logging of on the database and remove all
indexes on the new table. This will speed up the processing. Check to
see if your process has hung by monitoring IOs.
Regards
David Ashby
______________________________ Reply Separator _________________________________
Subject: Very Slow Process problem.
Author: <abhay@cheerful.com> at WCA-INET
Date: 21/4/98 2:54 PM
Environment : OnLine 7.23uc4 and PeopleSoft
One query is running for 18 hours and we don't want to kill the process.
Query goes like this :
insert into c
select distinct col1,col2.....coln
from a,b
where b.col1=some value
and a.col1= some value
and a.col2=b.col2
and a.col3=b.col3 ....
Table a has 700000 rows and b has 8000 rows.
I checked no. of rows in c and there is nothing.
Does it mean that the select is still running ?
Please help.
Thanks in advance.
Abhay Mannur