Rebuild Index?
From: Karth Panchan <keyantech_at_gmail.com>
Date: Fri, 28 Feb 2014 07:14:39 -0500
Message-Id: <E58E4B2F-6D33-49D5-924A-81199EB25FA0_at_gmail.com>
Everyone
Date: Fri, 28 Feb 2014 07:14:39 -0500
Message-Id: <E58E4B2F-6D33-49D5-924A-81199EB25FA0_at_gmail.com>
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-lReceived on Fri Feb 28 2014 - 13:14:39 CET