Re: Very Slow Process problem.

you have to give us what table has what index? If possible cut and paste of query plan ( SET Explain ON) Thanks Bala 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