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

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 Received on Thu Jul 13 2006 - 07:30:47 CDT