Re: Very Slow Process problem.
At 02:54 PM 21/04/98 -0400, Abhay Mannur wrote:
>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
>
Try:
1. CREATE INDEX idx_a ON a (col1)
CREATE INDEX idx_b ON b (col1).
2. LOCK TABLE c IN EXCLUSIVE MODE.
Best regards,
Danail Danailov