RE: Very Slow Process problem.
Hi
I would try :
Update statistics on table a & bDrop indexes on table c
set explain onrun statement
add index on table c
if problem still exist - post sqexplain.out
Lars Johansson
-----------------------------------------------
Dansk Software Kuwait Petroleum (Danmark)
Brydehusvej 23 Hummeltoftevej 49
2750 Ballerup 2830 Virum
lajo@dsr.dk lajo@q8.dk
Phone:4465 6070 Phone:4598 4291
-----------------------------------------------
> ----------
> From: Steve Romankiw[SMTP:sromankiw@execrisk.com]
> Sent: 22. april 1998 14:04
> To: abhay@cheerful.com
> Cc: Informix Mailing List
> Subject: 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
> -----------------------------------------------------------------
>
>