Jonathan Lewis has an interesting quiz on Oracle Indexes in answer to a question from the OTN forums:

“If I delete 90% of the rows from a table which has a few indexes, without rebuilding or coalescing indexes afterwards, will this improve the performance of index range scans ?”

Check out his Night Quiz blog entry for an excellent discussion on how things might be better, worse, unchanged or possibly all three in answer to the question.

I’ve received quite a number of emails and blog comments regarding errors in trying to access some of my older demos. There appears to be a problem with later versions of WordPress not supporting plain text files. I have on my to-do list the task of converting these files to PDF format so they can be generally viewable again. I hope to complete this thrilling task in the next week or so. Will keep you informed.

Finally, I had my paper on “10 Things You Possibly Don’t Know About Oracle Indexes” accepted for this years InSync11 Conference, to be held this year on 16-17 August 2011 at the Convention Centre in Sydney. As usual, there’s a great array of presenters including Tom Kyte, Connor McDonald, Chris Muir, Tim Hall, Graham Wood and Marcelle Kratochvil to name but a very few. Follow the link for the Full 2 Day Programme. Looking forward to it already and the opportunity to catch up with a lot of folks.

For those of you wondering, my negotiations with Manchester United, Barcelona and South Cooma Over 45’s Second 11 are still ongoing :)

search

Disclaimer

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle Corporation.

Contact Details

If you wish to contact me directly, please do so at richard.foote@bigpond.com