StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
3527081
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2010-08-19T23:27:11.730
FavoriteCount
0
LastActivityDate
2010-08-20T00:59:18.673
LastEditDate
2010-08-20T00:59:18.673
LastEditorUserId
67945
OwnerUserId
67945
ParentId
3527039
PostTypeId
2
Score
3
ViewCount
0
LastEditorDisplayName
text
Body
Please run the bellow query and post the results. <pre><code>EXPLAIN SELECT count(*) c FROM full_view WHERE verified > ( DATE (NOW()) - INTERVAL 30 DAY) </code></pre> The long forgotten <a href="http://dev.mysql.com/doc/refman/5.0/en/explain.html" rel="nofollow noreferrer"><code>EXPLAIN</code></a> almost always brings something in! ;) <hr> Edit 1: This is probably the offensive line: <pre><code>1, 'SIMPLE', 'f', 'ALL', '', '', '', '', 2214, '' </code></pre> The <code>ALL</code> there states that there is a FULL table scan. You can dig further into the <a href="http://www.pythian.com/news/wp-content/uploads/explain-diagram.pdf" rel="nofollow noreferrer"><code>Explain</code> syntax on this diagram</a>. Do try to see where the differences go... <hr> Edit 2: <a href="http://dev.mysql.com/doc/refman/5.0/en/explain-output.html" rel="nofollow noreferrer">This doc will sure make things much clearer on the <code>Explain</code> output. Please check it out.</a> <hr> Edit 3: Step-by-step analys of the explain command. <pre><code>1, 'SIMPLE', 'b', 'range', 'updated,verified_index', 'updated', '3', '', 28, 'Using where'` 1 - id SIMPLE - simple select, not using sub-queries b - table name range - only rows that are in a given range are retrieved, using an index updated,verified_index - are both possible keys updated - was the key eventually used 3 - key lenght '' - this is the ref column and would show which columns or constants are compared to the index name in the key column to select rows from the table. 28 - number of rows mysql believes it must examine to execute the query Using where - self explanatory </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POMySQL - Why is COUNT with "greater than" quick but "less than" takes forever?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USFrankie
UserOwnerUserId
1. USFrankie
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POMySQL - Why is COUNT with "greater than" quick but "less than" takes forever?
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.