Re: Very Slow Process problem.

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 ? > What indices do the tables have? Please post a schema of the tables. John Carlson Informix DBA WH Smith, Inc.