MENU
last data update: 2011/10/15, 04:14
Website loading time
during the test: 1.17 s
cable connection (average): 1.29 s
DSL connection (average): 1.42 s
modem (average): 7.95 s
HTTP headers
HTTP/1.1 200 OK
Date: Sat, 15 Oct 2011 11:14:20 GMT
Server: Apache/1.3.37 (Unix) PHP/5.2.10
Vary: Accept-Encoding,Cookie
Cache-Control: max-age=300, must-revalidate, max-age=300
Expires: Sat, 15 Oct 2011 11:19:20 GMT
Connection: close
Content-Type: text/html; charset=UTF-8
Information about DNS servers
explainextended.com | MX | 20 | ALT1.ASPMX.L.GOOGLE.com | IN | 3600 |
explainextended.com | MX | 20 | ALT2.ASPMX.L.GOOGLE.com | IN | 3600 |
explainextended.com | MX | 30 | ASPMX2.GOOGLEMAIL.com | IN | 3600 |
explainextended.com | MX | 30 | ASPMX3.GOOGLEMAIL.com | IN | 3600 |
explainextended.com | MX | 30 | ASPMX4.GOOGLEMAIL.com | IN | 3600 |
explainextended.com | MX | 30 | ASPMX5.GOOGLEMAIL.com | IN | 3600 |
explainextended.com | MX | 10 | ASPMX.L.GOOGLE.com | IN | 3600 |
explainextended.com | A | 212.193.239.244 | IN | 43200 | |
explainextended.com | SOA | ns3.nic.ru | support.nic.ru | 65012709 | 14400 3600 2592000 600 IN 3600 |
explainextended.com | NS | ns8.nic.ru | IN | 43200 | |
explainextended.com | NS | ns3.nic.ru | IN | 43200 | |
explainextended.com | NS | ns4.nic.ru | IN | 43200 |
Received from the first DNS server
Request to the server "explainextended.com"
You used the following DNS server:
DNS Name: ns8.nic.ru
DNS Server Address: 193.232.130.14#53
DNS server aliases:
HEADER opcode: REQUEST, status: NOERROR, id: 34306
flag: qr aa rd REQUEST: 1, ANSWER: 12, AUTHORITY: 0, ADDITIONAL: 0
REQUEST SECTION:
explainextended.com. IN ANY
ANSWER SECTION:
explainextended.com. 3600 IN SOA ns3.nic.ru. support.nic.ru. 65012709 14400 3600 2592000 600
explainextended.com. 86400 IN NS ns8.nic.ru.
explainextended.com. 86400 IN NS ns3.nic.ru.
explainextended.com. 86400 IN NS ns4.nic.ru.
explainextended.com. 86400 IN A 212.193.239.244
explainextended.com. 3600 IN MX 10 ASPMX.L.GOOGLE.com.
explainextended.com. 3600 IN MX 20 ALT1.ASPMX.L.GOOGLE.com.
explainextended.com. 3600 IN MX 20 ALT2.ASPMX.L.GOOGLE.com.
explainextended.com. 3600 IN MX 30 ASPMX2.GOOGLEMAIL.com.
explainextended.com. 3600 IN MX 30 ASPMX3.GOOGLEMAIL.com.
explainextended.com. 3600 IN MX 30 ASPMX4.GOOGLEMAIL.com.
explainextended.com. 3600 IN MX 30 ASPMX5.GOOGLEMAIL.com.
Received 333 bytes from address 193.232.130.14#53 in 83 ms
Received from the second DNS server
Request to the server "explainextended.com"
You used the following DNS server:
DNS Name: ns3.nic.ru
DNS Server Address: 194.85.61.20#53
DNS server aliases:
HEADER opcode: REQUEST, status: NOERROR, id: 8986
flag: qr aa rd REQUEST: 1, ANSWER: 12, AUTHORITY: 0, ADDITIONAL: 0
REQUEST SECTION:
explainextended.com. IN ANY
ANSWER SECTION:
explainextended.com. 3600 IN MX 10 ASPMX.L.GOOGLE.com.
explainextended.com. 3600 IN MX 20 ALT1.ASPMX.L.GOOGLE.com.
explainextended.com. 3600 IN MX 20 ALT2.ASPMX.L.GOOGLE.com.
explainextended.com. 3600 IN MX 30 ASPMX2.GOOGLEMAIL.com.
explainextended.com. 3600 IN MX 30 ASPMX3.GOOGLEMAIL.com.
explainextended.com. 3600 IN MX 30 ASPMX4.GOOGLEMAIL.com.
explainextended.com. 3600 IN MX 30 ASPMX5.GOOGLEMAIL.com.
explainextended.com. 3600 IN SOA ns3.nic.ru. support.nic.ru. 65012709 14400 3600 2592000 600
explainextended.com. 86400 IN NS ns8.nic.ru.
explainextended.com. 86400 IN NS ns3.nic.ru.
explainextended.com. 86400 IN NS ns4.nic.ru.
explainextended.com. 86400 IN A 212.193.239.244
Received 333 bytes from address 194.85.61.20#53 in 131 ms
Subdomains (the first 50)
Typos (misspells)
wxplainextended.com sxplainextended.com dxplainextended.com rxplainextended.com 4xplainextended.com 3xplainextended.com ezplainextended.com ecplainextended.com edplainextended.com esplainextended.com exolainextended.com exllainextended.com ex-lainextended.com ex0lainextended.com expkainextended.com exppainextended.com expoainextended.com explzinextended.com explsinextended.com explwinextended.com explqinextended.com explaunextended.com explajnextended.com explaknextended.com explaonextended.com expla9nextended.com expla8nextended.com explaibextended.com explaimextended.com explaijextended.com explaihextended.com explainwxtended.com explainsxtended.com explaindxtended.com explainrxtended.com explain4xtended.com explain3xtended.com explaineztended.com explainectended.com explainedtended.com | explainestended.com explainexrended.com explainexfended.com explainexgended.com explainexyended.com explainex6ended.com explainex5ended.com explainextwnded.com explainextsnded.com explainextdnded.com explainextrnded.com explainext4nded.com explainext3nded.com explainextebded.com explainextemded.com explainextejded.com explainextehded.com explainextensed.com explainextenxed.com explainextenced.com explainextenfed.com explainextenred.com explainexteneed.com explainextendwd.com explainextendsd.com explainextenddd.com explainextendrd.com explainextend4d.com explainextend3d.com explainextendes.com explainextendex.com explainextendec.com explainextendef.com explainextender.com explainextendee.com xplainextended.com eplainextended.com exlainextended.com expainextended.com explinextended.com | explanextended.com explaiextended.com explainxtended.com explainetended.com explainexended.com explainextnded.com explainexteded.com explainextened.com explainextendd.com explainextende.com xeplainextended.com epxlainextended.com exlpainextended.com expalinextended.com explianextended.com explaniextended.com explaienxtended.com explainxetended.com explainetxended.com explainexetnded.com explainextneded.com explainextedned.com explainextenedd.com explainextendde.com eexplainextended.com exxplainextended.com expplainextended.com expllainextended.com explaainextended.com explaiinextended.com explainnextended.com explaineextended.com explainexxtended.com explainexttended.com explainexteended.com explainextennded.com explainextendded.com explainextendeed.com explainextendedd.com |
Location
IP: 212.193.239.244
continent: AS, country: Russian Federation (RUS), city:
Website value
rank in the traffic statistics:
There is not enough data to estimate website value.
Basic information
website build using CSS
code weight: 47.46 KB
text per all code ratio: 35 %
title: EXPLAIN EXTENDED: efficient database queries in SQL.
description: How to create fast database queries
keywords: sql, optimize, database, query, MySQL, Oracle, SQL Server, Transact, MS, PostgreSQL, efficient, SELECT, LIMIT, execution plan, index, table
encoding: UTF-8
language: en-US
Website code analysis
one word phrases repeated minimum three times
Phrase | Quantity |
---|---|
the | 12 |
of | 7 |
task | 6 |
is | 6 |
and | 6 |
to | 5 |
for | 4 |
on | 4 |
in | 4 |
I’ve | 3 |
two word phrases repeated minimum three times
Phrase | Quantity |
---|---|
the task | 4 |
of the | 3 |
three word phrases repeated minimum three times
B tags
U tags
I tags
images
file name | alternative text |
---|---|
sql-server-query-plan.png | |
135779270_de2e30d0b1_z.jpg | Stack Overflow profile for Quassnoi |
MG_2538-e1288838824800.jpg | |
rss.png | |
email-icon-14x14.png | |
55159.png?theme=clean |
headers
H1
EXPLAIN EXTENDED
H2
What’s UNPIVOT good for?
Shared Plan and Algorithm Network Cache (SPANC)
MySQL: GROUP BY in UNION
MySQL: splitting aggregate queries
Things SQL needs: SERIES()
Late row lookups: InnoDB
Happy New Year!
PostgreSQL: parametrizing a recursive CTE
10 things in MySQL (that won’t work as expected)
Mixed ASC/DESC sorting in MySQL
H3
What’s UNPIVOT good for?
Shared Plan and Algorithm Network Cache (SPANC)
MySQL: GROUP BY in UNION
MySQL: splitting aggregate queries
Things SQL needs: SERIES()
Late row lookups: InnoDB
Happy New Year!
PostgreSQL: parametrizing a recursive CTE
10 things in MySQL (that won’t work as expected)
Mixed ASC/DESC sorting in MySQL
H4
H5
H6
internal links
address | anchor text |
---|---|
http://explainextended.com/ | EXPLAIN EXTENDED |
http://explainextended.com/2011/04/01/shared-plan-and-algorithm-network-cache-spanc/ | Shared Plan and Algorithm Network Cache (SPANC) |
http://explainextended.com/2011/06/30/whats-unpivot-good-for/ | What’s UNPIVOT good for? |
http://explainextended.com/2011/06/30/whats-unpivot-good-for/#comments | with 5 comments |
http://explainextended.com/2011/06/30/whats-unpivot-good-for/#more-5373 | Read the rest of this entry |
http://explainextended.com/category/sqlserver/ | SQL Server |
http://explainextended.com/2011/04/01/shared-plan-and-algorithm-network-cache-spanc/ | Shared Plan and Algorithm Network Cache (SPANC) |
http://explainextended.com/2011/04/01/shared-plan-and-algorithm-network-cache-spanc/#comments | with 5 comments |
http://explainextended.com/category/miscellaneous/ | Miscellaneous |
http://explainextended.com/2011/03/30/mysql-group-by-in-union/ | MySQL: GROUP BY in UNION |
http://explainextended.com/2011/03/30/mysql-group-by-in-union/#comments | with 2 comments |
http://explainextended.com/2011/03/30/mysql-group-by-in-union/#more-5304 | Read the rest of this entry |
http://explainextended.com/category/mysql/ | MySQL |
http://explainextended.com/2011/03/28/mysql-splitting-aggregate-queries/ | MySQL: splitting aggregate queries |
http://explainextended.com/2011/03/28/mysql-splitting-aggregate-queries/#comments | Comments enabled. I *really* need your comment |
http://explainextended.com/2011/03/28/mysql-splitting-aggregate-queries/#more-5282 | Read the rest of this entry |
http://explainextended.com/category/mysql/ | MySQL |
http://explainextended.com/2011/02/18/things-sql-needs-series/ | Things SQL needs: SERIES() |
http://explainextended.com/2011/02/18/things-sql-needs-series/#comments | with 9 comments |
http://explainextended.com/2011/02/18/things-sql-needs-series/#more-5239 | Read the rest of this entry |
http://explainextended.com/category/miscellaneous/ | Miscellaneous |
http://explainextended.com/2011/02/11/late-row-lookups-innodb/ | Late row lookups: InnoDB |
http://explainextended.com/2011/02/11/late-row-lookups-innodb/#comments | with 4 comments |
/2009/10/23/mysql-order-by-limit-performance-late-row-lookups/ | late row lookups |
/2009/10/23/mysql-order-by-limit-performance-late-row-lookups/ | the original article |
http://explainextended.com/2011/02/11/late-row-lookups-innodb/#more-5214 | Read the rest of this entry |
http://explainextended.com/category/mysql/ | MySQL |
http://explainextended.com/2010/12/31/happy-new-year-2/ | Happy New Year! |
http://explainextended.com/2010/12/31/happy-new-year-2/#comments | with 9 comments |
http://explainextended.com/2010/12/31/happy-new-year-2/#more-5177 | Read the rest of this entry |
http://explainextended.com/category/miscellaneous/ | Miscellaneous |
http://explainextended.com/2010/12/24/postgresql-parametrizing-a-recursive-cte/ | PostgreSQL: parametrizing a recursive CTE |
http://explainextended.com/2010/12/24/postgresql-parametrizing-a-recursive-cte/#comments | with 2 comments |
http://explainextended.com/2010/12/24/postgresql-parametrizing-a-recursive-cte/#more-5146 | Read the rest of this entry |
http://explainextended.com/category/postgresql/ | PostgreSQL |
http://explainextended.com/2010/11/03/10-things-in-mysql-that-wont-work-as-expected/ | 10 things in MySQL (that won’t work as expected) |
http://explainextended.com/2010/11/03/10-things-in-mysql-that-wont-work-as-expected/#comments | with 26 comments |
http://explainextended.com/2010/11/03/10-things-in-mysql-that-wont-work-as-expected/#more-5003 | Read the rest of this entry |
http://explainextended.com/category/mysql/ | MySQL |
http://explainextended.com/2010/11/02/mixed-ascdesc-sorting-in-mysql/ | Mixed ASC/DESC sorting in MySQL |
http://explainextended.com/2010/11/02/mixed-ascdesc-sorting-in-mysql/#comments | with 2 comments |
http://explainextended.com/2010/11/02/mixed-ascdesc-sorting-in-mysql/#more-5001 | Read the rest of this entry |
http://explainextended.com/category/mysql/ | MySQL |
http://explainextended.com/page/2/ | |
/ask-a-question | Ask me a question |
/drop-me-a-line | Drop me a line |
http://explainextended.com/2011/06/30/whats-unpivot-good-for/ | What’s UNPIVOT good for? |
http://explainextended.com/2011/04/01/shared-plan-and-algorithm-network-cache-spanc/ | Shared Plan and Algorithm Network Cache (SPANC) |
http://explainextended.com/2011/03/30/mysql-group-by-in-union/ | MySQL: GROUP BY in UNION |
http://explainextended.com/2011/03/28/mysql-splitting-aggregate-queries/ | MySQL: splitting aggregate queries |
http://explainextended.com/2011/02/18/things-sql-needs-series/ | Things SQL needs: SERIES() |
http://explainextended.com/2011/06/ | |
http://explainextended.com/2011/06/ | June 2011 |
http://explainextended.com/2011/04/ | April 2011 |
http://explainextended.com/2011/03/ | March 2011 |
http://explainextended.com/2011/02/ | February 2011 |
http://explainextended.com/2010/12/ | December 2010 |
http://explainextended.com/2010/11/ | November 2010 |
http://explainextended.com/2010/10/ | October 2010 |
http://explainextended.com/2010/09/ | September 2010 |
http://explainextended.com/2010/08/ | August 2010 |
http://explainextended.com/2010/07/ | July 2010 |
http://explainextended.com/2010/06/ | June 2010 |
http://explainextended.com/2010/05/ | May 2010 |
http://explainextended.com/2010/04/ | April 2010 |
http://explainextended.com/2010/03/ | March 2010 |
http://explainextended.com/2010/02/ | February 2010 |
http://explainextended.com/2010/01/ | January 2010 |
http://explainextended.com/2009/12/ | December 2009 |
http://explainextended.com/2009/11/ | November 2009 |
http://explainextended.com/2009/10/ | October 2009 |
http://explainextended.com/2009/09/ | September 2009 |
http://explainextended.com/2009/08/ | August 2009 |
http://explainextended.com/2009/07/ | July 2009 |
http://explainextended.com/2009/06/ | June 2009 |
http://explainextended.com/2009/05/ | May 2009 |
http://explainextended.com/2009/04/ | April 2009 |
http://explainextended.com/2009/03/ | March 2009 |
http://explainextended.com/2009/02/ | February 2009 |
http://explainextended.com/category/meta/ | Meta |
http://explainextended.com/category/miscellaneous/ | Miscellaneous |
http://explainextended.com/category/mysql/ | MySQL |
http://explainextended.com/category/oracle/ | Oracle |
http://explainextended.com/category/postgresql/ | PostgreSQL |
http://explainextended.com/category/sqlserver/ | SQL Server |
external links
address | anchor text |
---|---|
http://stackoverflow.com/questions/5518080/distinct-optimization | http://stackoverflow.com/questions/5518080/distinct-optimization |
http://stackoverflow.com | Stack Overflow |
http://stackoverflow.com/questions/5486857/using-order-by-null-in-a-union | Stack Overflow |
http://www.postgresql.org/docs/9.0/static/queries-with.html | http://www.postgresql.org/docs/9.0/static/queries-with.html |
http://www.cracked.com/ | cracked.com |
http://stackoverflow.com/questions/4020625/how-can-i-optimize-this-confusingly-slow-query-in-mysql | Stack Overflow |
http://www.mysqlperformanceblog.com/2006/05/09/descending-indexing-and-loose-index-scan/ | the most well-known examples |
http://feeds.feedburner.com/explainextended | |
http://feedburner.google.com/fb/a/mailverify?uri=ExplainExtended&loc=en_US | |
http://lucianmarin.com/ | Lucian E. Marin |
http://wordpress.org/ | WordPress |