Re: Oracle Table Partitioning

See the latest issue of Relate.
It works, but there are a number of bugs, which could affect the benefit you could get from it.

At present (7.3.2.2) I would limit your expectation to simple queries on fairly small UNIONS.

Basic guideline for use: every table should be (virtually) identical to every other table; indexes must match across tables; constraints are the best restriction on selectivity; use to_date() in date column constraints.

The manuals (7.3) have an error: the constrained columns do not need to be indexed.

---
Jonathan Lewis
ora_mail_at_jlcomp.demon.co.uk