Re: Performance issue

From: Peter McKenzie <pemmck_at_ibm.net>
Date: 1998/01/13
Message-ID: <69f3ke$9ig$1@marri.bs.wa.gov.au>#1/1

I have just realised that there is an error in my posting. Corrected version follows !
Peter McKenzie wrote in message <69ckbm$6qq$1_at_marri.bs.wa.gov.au>...
>Oracle 7.3.....
>
>I have two tables - 'A' and 'B' with identical structures. Both are indexed
>on column X.
>
>I have a view 'C' = select * from A union all select * from B.
>

If have another table D with a column X and a column Y which is indexed. If I select * from D, C where D.X=C.X
and D.Y > 'a certain value';
I would like Oracle to scan table D using the index on column Y and then join to the view using the indexes on column X for tables A and B

The column X indexes on view tables A and B are not used - no indexes are used on these tables.

I have tried using hints and various other tricks but Oracle refuses to use
>the indexes.
>
>Any ideas welcome
>
>Thanks,
>Peter
>
>
Received on Tue Jan 13 1998 - 00:00:00 CST