Index Sample Size

Posted Leave a commentPosted in Indexes, Oracle, Table stats

Recently i was asked a question, what would be the sample size percentage for indexes when tables stats are gathered with estimate percent of 5 and cascade set to true.My answer to it was 5 within a second.I had this believe that the sample size percentage for an index is same to the estimate_percent given […]

Incremental stats on partitioned tables – Blogs to read

Posted Leave a commentPosted in 11gR2, Incremental Stats, Oracle, Table stats

Recently in past one week i read few blogs on “Incremental stats on partitioned tables”, which i felt are worth mentioning for remembering it myself and might be helpful to some others too. http://oracle-randolf.blogspot.com/2012/01/incremental-partition-statistics-review.html http://rnm1978.wordpress.com/2010/12/31/data-warehousing-and-statistics-in-oracle-11g-incremental-global-statistics/ http://jhdba.wordpress.com/2012/01/04/speeding-up-the-gathering-of-incremental-stats-on-partitioned-tables/ Happy reading 🙂