So, do you recommend creating a kind of temp table, that contains all
of the project ids?
Frank van Bortel wrote:
> Maxim Demenko wrote:
> > jimi_xyz_at_hotmail.com schrieb:
> >
> >> NOTE: There is about 1884 values within the IN () function. AND..
> >
> >
> >>
> >> Any help/ideas will do.
> >>
> >> Thanks Inadvance
> >> Jimi
> >>
> >
> > Maybe this helps
> > http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/expressions014.htm#sthref2245
> >
> >
> > <quote>
> > A comma-delimited list of expressions can contain no more than 1000
> > expressions. A comma-delimited list of sets of expressions can contain
> > any number of sets, but each set can contain no more than 1000 expressions.
> > </quote>
> >
> > Best regards
> >
> > Maxim
> And with reason, I'd say.
>
> Having 1000 (or more - as you have) elements in such an IN list
> triggers the thought you are missing a table that can be referenced
> through a foreign key.
> More efficient than an IN list, too.
>
> So, rethink the design.
>
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
Received on Thu Nov 03 2005 - 12:40:36 CST
