Re: select/delete on IOT becomes slower as more rows get deleted
From: (wrong string) 조동욱 <ukja.dion_at_gmail.com>
Date: Thu, 5 Feb 2009 11:16:28 +0900
Message-ID: <43c2e3d60902041816j61ac8e82l61ef98794d48baf1_at_mail.gmail.com>
Yes, I think that Richard gave OP the exact explanation.
Dion Cho - Oracle Performance Storyteller
Date: Thu, 5 Feb 2009 11:16:28 +0900
Message-ID: <43c2e3d60902041816j61ac8e82l61ef98794d48baf1_at_mail.gmail.com>
Yes, I think that Richard gave OP the exact explanation.
As more keys are deleted from IOT(index), the select statement would read more blocks to retrieve first key.
Dion Cho - Oracle Performance Storyteller
http://dioncho.wordpress.com (english)
http://ukja.tistory.com (korean)
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Feb 04 2009 - 20:16:28 CST