"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.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Fri Jul 05 2002 - 15:39:05 CDT
