Re: Partitioning tables in Oracle8

There is no automatic creation of indexes.

If you want a unique/PK index on the table it has to be either a global (i.e. cross-partition) index or it has to start with the partitioning columns - Apart from this there is no need to have an index on the partitioning column at all.

Performance can be dramatically improved if your partition is correctly selected.

A suggestion for analyzing if (do you really need to do it every night ?) is to analyze the partitions separately, not the table as a whole: the only time to analyze the table is when you initially create it with empty partitions.

larionov_at_yahoo.com wrote in article
<6knaef$9vo$1_at_nnrp1.dejanews.com>...
> Hi,
>
> I wondering, when create partitioned table in Oracle8,
> should I create an index on the column the partition is going to
> be based on or the index is created automatically?
>
> Aslo, what is your experience in using partitioned tables?
> Does it improve performance. The table I keep in mind
> is a kind-of large table (~10G) and there are multiple upates
> of random rows durig daytime and analysis on this table
> is performed during nighttime.
>
Received on Sat May 30 1998 - 03:14:41 CDT