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. Are there any
other strategies in order to get joined data sets.

select * from table1, table2 where tabe2.table1_id = table1.id

many thanks

regards
Mark

joes wrote:
No version
No platform
No error message, other than something like 'normally my client and
server is getting out ot memory' (whatever that is), with only 'hunderd
thousand of entries'

Could you please verify you are actually running Oracle, and not some
fancy 'free' database toy?

Joining two tables is absolutely a piece of cake for Oracle, provided
the administrator did configure the database and the server properly.

--
Sybrand Bakker
Senior Oracle DBA

joes schreef:
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...