Re: Index Across Tables

From: Mark Townsend <markbtownsend_at_attbi.com>
Date: Sat, 06 Jul 2002 02:16:12 GMT
Message-ID: <B94BA0FD.38A91%markbtownsend@attbi.com>

in article 3d2603e8$0$8510$cc9e4d1f_at_news.dial.pipex.com, Niall Litchfield at niall.litchfield_at_dial.pipex.com wrote on 7/5/02 1:39 PM:

> "Donna Yorukoglu" <dym7_at_outreach.psu.edu> wrote in message
> news:8ede3df2.0207051122.7529f90d_at_posting.google.com...

>> I have one multi-column index (using a concatenated datastore).  Works
>> great.  However, I would like to either create a new index on another
>> table and then join the indices or create one index across both
>> tables.  Are either of these options possible with Oracle 8.1.7?  Any
>> advice would be greatly appreciated.

>
> Joining indexes makes no sense. if you index the relevant columns then (if
> appropriate) oracle will use both indexes to get to the data.
>

Hmm - not necessarily. A join index (aka a materialized view across two or more tables) can be useful in some circumstances. And the new bit mapped join indexes in Oracle9i rock. Received on Fri Jul 05 2002 - 21:16:12 CDT