Re: Simple query makes Oracle hang

Also not responding means that the query has not complete on the server side so it is waiting for the result set to come back. Jim

"Greg Vitetzakis" <greg_at_ostnet.com> wrote in message news:3a8462a7$1_at_news1...
> select file_name from Filatable FT
> where filetypeID= 2
> and
> FileCategory NOT EXISTS
> ( select filecategory FC
> from fileCat
> Where FT.FileCategory = FC.FileCategory);
>
> Try this instead.
>
> Make sure the FileCategory fields are indexed.
>
>
>
> Greg Vitetzakis
> <faheemrao_at_my-deja.com> wrote in message
 news:93dgrg$f4s$1_at_nnrp1.deja.com...
> >
> >
> > I have a problem in running a simple SQl query.
> >
> >
> > This is very strange that the following query makes all oracle front
> > end tool makes "not responding". including sql plus and Oracle
> > worksheet.
> >
> > select file_name from Filatable
> > where filetypeID= 2
> > and
> > FileCategory NOT IN ( select filecategory from fileCat)
> >
> >
> > But if omit the not operator that query runs fine.
> >
> >
> > select file_name from Filatable
> > where filetypeID= 2
> > and
> > FileCategory IN ( select filecategory from fileCat)
> >
> >
> > I am badly struck with that problem.
> >
> >
> > any help would do a lot
> >
> > Thanks in advance.
> >
> > Faheem Rao
> >
> >
> >
> >
> >
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>
Received on Fri Feb 09 2001 - 22:37:02 CST