Re: Rebuild Index?
From: Lyall personal <lyallbarbour_at_sanfranmail.com>
Date: Fri, 28 Feb 2014 07:23:24 -0500
Message-ID: <20140228122324.5222541.52547.4743_at_sanfranmail.com>
Date: Fri, 28 Feb 2014 07:23:24 -0500
Message-ID: <20140228122324.5222541.52547.4743_at_sanfranmail.com>
I've never seen an index rebuild gaining significant performance benefits. If that's really his last resort, i'd tell him to look at the application use of this table and index first.
If the was a massive archiving or batch load recently, there's definitely cause for a rebuild. But...
Also, just a shot in the dark, you said lots of inserts, updates and deletes right? Is it a bitmap or normal index? I've seen OLTP applications grind to a halt over time with bitmap indexes on tables that get worked on a lot. Therefore change index to a normal one, that would be a better reason to rebuild it then that it's larger then the table.
Lyall
Sent from my BlackBerry 10 smartphone.
From: Karth Panchan Sent: Friday, February 28, 2014 7:16 AM To: oracle-l_at_freelists.org Reply To: keyantech_at_gmail.com Subject: Rebuild Index? |
Everyone
We have table with lot of insert/update/delete every day. High OLTP application in 11g R2 on Linux.
To gain performance my teammate recommend Rebuild index.
His assumption Index size should be less than table size. Other wise we need to rebuild index.
Is that correct? Want get your thoughts.
I am skeptic after Reading Asktom and Jonathan Lewis blog. Both of them claim need good metrics and it is last option.
Thanks
Karth
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 28 2014 - 13:23:24 CET
We have table with lot of insert/update/delete every day. High OLTP application in 11g R2 on Linux.
To gain performance my teammate recommend Rebuild index.
His assumption Index size should be less than table size. Other wise we need to rebuild index.
Is that correct? Want get your thoughts.
I am skeptic after Reading Asktom and Jonathan Lewis blog. Both of them claim need good metrics and it is last option.
Thanks
Karth
--
http://www.freelists.org/webpage/oracle-l