Re: Newbie: Oracle join issue, too many entries for a join

joes schreef:
> Hello
>
> I need some advises of DB gurus. I have 2 tables with each hundert
> thousands of entries. The table have a 1:n relationship. IF I jon them
> normally my client and server is getting out of memory.

get a bigger client - it shouldn't get out of memory by displaying a mere million records or so.
We all do this on a daily basis, don't we?

In all seriousness, why display several hundreds of thousand records?

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...