Partitioning tables in Oracle8

From: <larionov_at_yahoo.com>
Date: Fri, 29 May 1998 21:47:59 GMT
Message-ID: <6knaef$9vo$1@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.

Thank you!

Michael.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 29 1998 - 16:47:59 CDT