Apache Derby
Graphical Query Explainer
Query: SELECT a.USER_ID, a.USER_NAME, b.account_id FROM Users a JOIN Messaged_Users b ON a.USER_ID=b.USER_ID AND b.account_id=(?)
- PROJECTION
returned_rows 1 no_opens 1 -
|_
HASHJOIN
returned_rows 1 no_opens 1 -
|_
TABLESCAN
returned_rows 100000 no_opens 1 visited_pages 2165 scan_qualifiers None scanned_object USERS scan_type HEAP -
|_
HASHSCAN
returned_rows 1 no_opens 100000 visited_pages 3 scan_qualifiers None next_qualifiers Column[0][0] Id: 1 Operator: = Ordered nulls: false Unknown return value: false Negate comparison result: false scanned_object PK_ACC_USER_ID scan_type BTREE
-
|_
TABLESCAN
-
|_
HASHJOIN
