Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index Across Tables
"Mark Townsend" <markbtownsend_at_attbi.com> wrote in message
news:B94CFF6E.38B04%markbtownsend_at_attbi.com...
> in article ag80ig$rr3$1_at_lust.ihug.co.nz, Howard J. Rogers at
dba_at_hjrdba.com
> wrote on 7/6/02 5:03 PM:
>
> > All perfectly true, but that still doesn't make the bitmap join index an
> > index 'across tables'.
>
> I guess we will have to differ on the semantics - but I still think an
index
> that indexes every distinct value in a column of one table, but references
> the rows in another table, without the need for the column to be repeated
in
> both tables, IS an index across tables.
>
> Without using the other alternative of storing the join as a materialized
> view, what would you suggest an index across two tables actually looks
like
> ?
>
Create index blah on emp(empno), dept(deptno).
I.E., Containing data from two tables, rather than merely an inference of the joined data from the second.
Regards
HJR
Received on Sat Jul 06 2002 - 23:05:05 CDT