Re: ORACLE Data Partitioning?

Be warned:

In Oracle V6 the optomiser did not use indexes when querying views with a UNION in it, I do not know if this has changed in V7

Best of luck

Eddyarmsteadm_at_aol.com (ARMSTEADM) wrote:
>
> Then create a view:
> CREATE VIEW TOTAL_DATA AS
> SELECT * FROM 1991_DATA
> UNION
> SELECT * FROM 1992_DATA
> UNION
                          ...... Received on Thu May 04 1995 - 00:00:00 CEST