Re: Partition Drops is effecting performance adversely...

Ravi,

Have you consider using local indexing instead of global indexes? My 1.6T database also uses weekly partitions with local indexes. Several tables are about 30 million rows per partition or 2 billion rows total.  Stats are collected on the partitions that are loading; older partition tablespaces are placed into "read only" mode as they age. Dropping a partition is fast and easy and does not invalidate any indexes or stored procedures.

Margaret Received on Fri Sep 30 2005 - 10:04:05 CDT