Re: Is it possible to link two big tables which are joined together frequently?

On 4 Jan 1998 14:47:17 GMT, dshi_at_magpage.com (David Shi) wrote:

>I haven't got anwser on this one, and later I thought about using rowid to link
>the two table, basically join the two big tables once and store rowid for each
>joined row into a table, then every time when the two table need to be joined
>again, use a PL/SQL code like in the following. I assume since rowid is the
>fastest way to access a row, this will be much faster than doing a join every
>time.

Rowids are NOT static! They may change in time - and they certainly change upon restore/recreation. I can not recommend storing a rowid PERMANTLY. For a tempoary table it might be a good shortterm solution - but not for permanent data.

Regards
Peter H. Larsen (petlars_at_pip.dknet.dk)
Oracle Consultant (not affiliated with Oracle) Received on Mon Jan 05 1998 - 00:00:00 CST