query for viewing all posts by some user or posts having any specific value

Question

On data.stackexchange I am unable to get any results(rows) from following quries

select Top 10 * from Posts where OwnerDisplayName = 'Rodolphe';
select * from Posts where OwnerUserId=992165; // My user id
select * from Posts where OwnerUserId=603393; // Rodolphe id

The query which is giving results(rows)

select Top 10 * from Posts order by CreationDate desc;

But even the last query giving latest results of 2012-06-27 which is not understandable for me

Does data.stackexchange only show the posts or user of it and not the stackoverflow?

If thats the case how can i find the posts on stackoverflow of my specific interest

Answer 1

The data dump used for data.stackexchange.com is updated once every few months. The last update was on June 27th (as listed on the data-explorer homepage).

You were not active on Stack Overflow until July 16th, and thus don't have anything listed in the Posts table. You are listed in the Users table though.

Note that for me, the select * from Posts where OwnerUserId=603393 query does return results. The where OwnerDisplayName probably just times out, that column is not indexed (I suspect) and thus a complete table scan would be needed to find matching rows.