Oracle 8 - partition tables.

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 1997/09/07
Message-ID: <01bcbb5d$4a3aa040$294b989e@WORKSTATION>#1/1

Has anyone yet put in sufficient time with oracle 8's partitioned tables to
answer the following questions:

On a table with 750 partitions (2 years plus a bit, tables) do you get the massive parse overhead
that you get on 7.3's partition views ?

If your partition is defined on 'columnx', does a predicate of the form:

	and
		(   columnx between v1 and v2
		 or
		   columnx between v3 and v4
		)

result in partition elimination ? (It doesn't in partition view's under 7.3)          Received on Sun Sep 07 1997 - 00:00:00 CDT