tag:blogger.com,1999:blog-7461233846321640962.post7046540319001027017..comments2022-12-08T06:13:12.219+00:00Comments on Oracle Performance and Backup Blog: Rolling partition and global index - do we need to rebuild ?Marcin Przepiorowskihttp://www.blogger.com/profile/15133397892511680504noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-7461233846321640962.post-88829170483907187572011-10-07T20:17:31.308+01:002011-10-07T20:17:31.308+01:00Hi Martin,
I've been investigating a performa...Hi Martin,<br /><br />I've been investigating a performance problem with an insert...select statement which, once traced, showed a large number of slow db file sequential reads on the indexes on the table being inserted (indexes not part of the statement execution plan but obviously insert requires index maintenance and unique keys require validation).<br /><br />This was a partitioned table - partitioned by range (daily date), and then sub partitioned by list. There was a global unique index - a composite index - on this table which included the partition key in position 3 I think but did not include the subpartition key. Maintenance to drop off the old partitions using "update global indexes" was done at the weekend.<br /><br />To cut a long story short, it fits with the situation you've described.<br /><br />Thanks.<br /><br />Cheers,<br />DominicDomBrookshttps://www.blogger.com/profile/02598622186013843759noreply@blogger.comtag:blogger.com,1999:blog-7461233846321640962.post-29746258458544568672011-06-10T08:46:11.996+01:002011-06-10T08:46:11.996+01:00Definitely read Richard before me. He's the ex...Definitely read Richard before me. He's the expert.Niallhttps://www.blogger.com/profile/07109750882834293686noreply@blogger.com