I had a very pleasant day yesterday at a SIG meeting of the UK Oracle User Group where I did the presentation about “drawing your SQL” that is the basis of the article I wrote for Simple Talk a little while ago.
One of the other sessions had the entertaining title: “What happens if you drop [...]
Anyone who’s keen to keep track of how the cost based optimizer does its arithmetic, and how that arithmetic can change with version, may want to keep an eye on this blog.
In an earlier article about investigating the state of an index in detail I supplied a piece of SQL that would analyse an index (no, not using the Analyze command) and summarise the number of entries in each leaf block that currently held any entries at all. Here’s a sample of the type of output [...]
I’ve just had another email about translating some of my postings, in this case into French. Franck Pachot has asked if he can post translations on his blog, and the answer is yes.
His intention is to select the postings which are more about how the database engine works, rather than examples of specific solutions, and [...]
Following on from my posting about the presentation (about Enterprise databases) that I did at a Microsoft event on SQL Server 2008, I’ve just had an article on how to design efficient SQL published on a website that’s strongly biased towards SQL Server developers – using an example of SQL written in the SQL Server dialect.
It’s [...]
My last posting about indexes was an introduction to a pl/sql script that estimated the sizes that your indexes would be if you rebuilt them at a given percentage of utilisation for leaf blocks. By comparing these estimates with the actual size of the indexes you can get a quick report of indexes that are probably significantly [...]
… to let peopl know that there’s a new item on the “Chinese Translation” catalogue.
Some time ago I wrote a note on index efficiency that referenced, in one of the comments, an article on my old website about how you could use existing statistics to estimate the “correct” size of an index.
A little while ago, while applying the concept on a client site and implementing a mechanism that would [...]
One of the members of the Oak Table Network sent me a link to an article about Websites and SQL Injection a couple of days ago. It’s a simple little story and though I’m always a little suspicious of believing every article I read on the Internet, I can’t help thinking that this one is probably [...]
It’s an old posting, but I came across this item a few days ago where Tom Kyte has listed URLs to several of the useful utilities that he has published on the Internet.
(I’m hoping the print_table() routine will appear on the list some time soon. It’s disappeared from the link I used to have for [...]
A DBA from China has asked if he can translate some of my material for publication on his blog, and I’ve given him the go-ahead – provided he emails me each time he publishes a piece. There’s a new link in the panel to the right that takes you to a catlogue of the pieces [...]
RSS
Email