Re: Oracle Table Partitioning

From: Jonathan Lewis <ora_mail_at_jlcomp.demon.co.uk>
Date: 1996/12/09
Message-ID: <32AC8239.3E9D_at_jlcomp.demon.co.uk>#1/1


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
Received on Mon Dec 09 1996 - 00:00:00 CET

Original text of this message