RE: Rebuild Index?
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <jonathan@xxxxxxxxxxxxxxxxxx>, <keyantech@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 28 Feb 2014 07:52:47 -0500
+1
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Jonathan Lewis
Sent: Friday, February 28, 2014 7:36 AM
To: keyantech@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Rebuild Index?
It's not often that you would expect an index to be larger than the
underlying table - and when it is it's possible that it should be an index
organized table anyway; so your colleague has an informal argument for why
an index rebuild in this case might be appropriate. I would work out how
big the index ought to be given its data content before doing the rebuild,
though; then monitor for time lost on things like "TX enq: index contention"
and "buffer busy wait" waits. It's also important to figure out WHY the
index has grown larger than necessary and see if you can work out a method
for avoiding the growth
If you want some code to check "reasonable size" for an index, then check my
blog: http://jonathanlewis.wordpress.com/index-sizing/
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on
behalf of Karth Panchan [keyantech@xxxxxxxxx]
Sent: 28 February 2014 12:14
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
