Re: Very Slow Process problem.
Abhay:
Have you done a "set explain on" on the SELECT statement to see what the
optimizer is thinking? What is the "expected" result size of the SELECT?
SteveR
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
--
-----------------------------------------------------------------
Steve Romankiw +
Executive Risk Inc. +
DBA + email: sromankiw@execrisk.com
82 Hopmeadow Street + work: (860) 408-2474
Simsbury,CT 06070 + fax: (860) 408-2139
-----------------------------------------------------------------