Oracle Logbook

November 22, 2011

Greatly Boosting Buffer Cache Efficiency with IOT

Filed under: Uncategorized — heliodias @ 3:41 pm

One very important thing regarding the IOT is the clustering factor.

Since the data are stored together according to the PK, as a bonus you decrease the amount of buffer cache usage.

Martin Widlake wrote a wonderful article about it:

http://mwidlake.wordpress.com/2011/08/08/iot-part-4-greatly-boosting-buffer-cache-efficiency/

 

Theme: Rubric. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.