Skip to content

Instantly share code, notes, and snippets.

@abarth500 abarth500/gist:8287893
Last active Jan 2, 2016

Embed
What would you like to do?
[データベースシステム論] 第12回 問い合わせ処理と最適化 SQL文
EXPLAIN
SELECT * FROM wine_list WHERE wid = 1;
set ENABLE_NESTLOOP to off;
EXPLAIN
SELECT * FROM wine_list WHERE wid = 1;
set ENABLE_HASHJOIN to off;
EXPLAIN
SELECT * FROM wine_list WHERE wid = 1;
set ENABLE_NESTLOOP to on;
set ENABLE_HASHJOIN to on;
EXPLAIN
SELECT *
FROM (SELECT * FROM zipcode) AS a;
SELECT *
FROM wine_list
WHERE price > 3000;
EXPLAIN
SELECT *
FROM wine_list;
EXPLAIN
SELECT *
FROM wine
WHERE price > 3000;
EXPLAIN
SELECT *
FROM wine_list
WHERE price > 3000;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.