Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Indexes in Union Views
As well as looking at UNION ALL, you need to look at partition views - check my web-site for a couple of articles. Partition views are a deprecated feature, but they still work in current versions of Oracle.
In newer versions (you really ought to upgrade from 8.0.5) Oracle has all sorts of clever optimisation paths which mean that you can frequently get the benefits of partition views on any type of UNION ALL views.
-- Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases Rolf Unger wrote in message <32fe19ad.0204021332.dd8b022_at_posting.google.com>...Received on Sat Apr 06 2002 - 08:23:50 CST
>Hi,
>
>I have a question regarding union views and indexes.
>(using Oracle 8.0.5 on WinNT).
>
>I have several tables log_entries_1, log_entries_2, ..
>all of the type:
>
>log_string varchar2(100)
>log_date date
>