Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Table Partitioning

Re: Oracle Table Partitioning

From: Jonathan Lewis <ora_mail_at_jlcomp.demon.co.uk>
Date: 1996/12/09
Message-ID: <32AC8239.3E9D@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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US