Ignacio Ruiz's Page

If you want to read about how UPDATE works at block level and some ugly cases where you can flood the blocks and waste space, follow this link for English version UPDATE under the hood ...and some extreme side effects... or follow this link for Spanish text UPDATE interno... y sus efectos secundarios.



Hope you find it useful, please… Continue

Continuing with this series, where you can explore real life observations for regular Index behavior, within a living ERP system. This post present final results for this experiment, both in English Index Dynamics - Part 3 and Spanish Dinamica de Indices - Parte 3. I'll share a small recommendation derived from experiment: try not rebuild indexes before high… Continue

More than a year ago started a series of posts about Index Dynamics (initial post click here), don't know why, but updates on Oracle Community were miserably forgotten... anyway, today will resume and share with you real life results with a set of indexes from a live ERP system, armed with tools like statement ANALYZE INDEX and table INDEX_STATS. Full English text is available here… Continue

I have started a series about how B-Tree Index behave in Oracle databases, please read this proposal and leave any feedback and comments, thank you in advance.

You may access the content in English here Index Dynamics or in Spanish here Dinamica de Indices en Oracle

I appreciate your time
Ignacio Ruiz

Yeeeesss,!!! Larry Elison is releasing right now at OOW2008, which is the first attempt to enter the hardware market, in partnership with HP, offering which is the greatest improvement on Database technology, with improvements on performance that range from 10x minimum, Exadata establish a milestone for… Continue