Page hits

Another landmark – this morning the blog counter reached 750,000. It’s taken a little longer to get the third 250,000 than it did the second – but given how little I’ve written over the last few months it’s still a pleasant surprise.

WordPress supples some interesting stats, so I’ve copied up the top three entries for populare posts. [Edited: I did have an icon to the right that I though would let you see the stats for the post - but you have to log in as me to see them. The point of putting the icon there was to show that these searches show a fairly uniform pattern of arrival, rather than occasional peaks]

Cartesian Merge Join	10,718
Bind Variables	8,660
dbms_xplan in 10g	6,562

There’s also a section in the statistics about search times – unsurprisingly searches for my name, or the blog name feature quite highly, but the three commonest search terms are quite interesting:

ora-01722	1,418
oracle not in	1,231
merge join cartesian	1,162

All three of these look like search terms that are likely to have come from end-users who have been surprised by changes in execution plans after an upgrade to 10g.