index hash join - SERP Analysis

https://use-the-index-luke.com/sql/join/hash-join-partial-objects

https://community.spiceworks.com/t/hash-join-vs-indexed-join/631645

https://docs.teradata.com/r/Enterprise_IntelliFlex_VMware/Database-Design/Join-and-Hash-Indexes

https://readyset.io/blog/introducing-hash-join-algorithm

https://en.wikipedia.org/wiki/Hash_join

https://www.ibm.com/docs/en/informix-servers/14.10.0?topic=plan-hash-join

https://asktom.oracle.com/ords/asktom.search?tag=hash-joining-versus-index

https://learn.microsoft.com/en-us/answers/questions/85209/tipping-point-nested-loop-join-and-hash-join

https://dba.stackexchange.com/questions/308662/why-does-an-index-on-the-join-predicate-does-not-improve-the-performance-of-a-ha

https://stackoverflow.com/questions/78131339/postgresql-hash-join-vs-nested-loop-and-hash-index

https://dev.mysql.com/doc/refman/8.3/en/hash-joins.html

https://www.interdb.jp/pg/pgsql03/05/03.html

https://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00743.1570/html/queryprocessing/queryprocessing62.htm

https://www.percona.com/blog/understanding-hash-joins-in-mysql-8/

https://docs.teradata.com/r/Enterprise_IntelliFlex_VMware/Database-Design/Database-Level-Capacity-Planning-Considerations/Hash-and-Join-Index-Row-Structures

https://richardfoote.wordpress.com/category/hash-join/

https://docs.pingcap.com/tidb/stable/explain-joins

https://discourse.getdbt.com/t/understanding-hash-joins-in-redshift-query-plan/122

https://asktom.oracle.com/ords/asktom.search?tag=how-to-get-hash-index-join-before-table-access

https://gelovolro.medium.com/what-are-merge-join-hash-join-and-nested-loop-example-in-postgresql-29123ca18fd1

https://learn.microsoft.com/en-us/answers/questions/684645/how-to-reduce-high-cost-index-seek-and-hash-match

https://www.cybertec-postgresql.com/en/join-strategies-and-performance-in-postgresql/

https://www.ibm.com/docs/en/informix-servers/14.10.0?topic=optimization-nested-loop-joins-versus-hash-joins

https://oracle.readthedocs.io/en/latest/sql/joins/hash-join.html

https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-datacom/15-1/using/using-sql/hash-join.html

https://sqlity.net/en/1490/a-join-a-day-the-hash-join/

https://www.youtube.com/watch?v=pJWCwfv983Q

https://rafaelrampineli.medium.com/optimizing-sql-server-joins-understanding-nested-loops-hash-match-merge-join-and-adaptive-join-5ba57fcf6ec3

https://dba.stackexchange.com/questions/180373/why-is-my-index-on-the-join-keys-not-used-in-a-very-simple-hash-join-case

https://forums.sqlteam.com/t/how-to-reduce-high-cost-index-seek-and-hash-match-inner-join-when-analysis-execution-plan-issue/20398

https://jonathanlewis.wordpress.com/2010/11/22/index-join/

https://tanelpoder.com/2010/10/06/a-the-most-fundamental-difference-between-hash-and-nested-loop-joins/

https://www.couchbase.com/forums/t/hashjoin-is-taking-60-of-the-time-in-explain-plan/30104

https://bugs.mysql.com/97302

https://www.tek-tips.com/threads/why-the-optimizer-chooses-hash-join-over-index-join.1139291/

https://www.linkedin.com/learning/advanced-sql-for-query-tuning-and-performance-optimization-22894038/hash-joins

https://www.sqlservercentral.com/forums/topic/hash-join-in-query-even-after-having-clustered-index

http://dev.cs.ovgu.de/db/sybase9/help/dbugen9/00000401.htm

https://www.postgresql.org/message-id/14589.962175604%40sss.pgh.pa.us

https://github.com/h2database/h2database/issues/2081

https://www.youtube.com/watch?v=J0nbgXIarhc

https://www.youtube.com/watch?v=vjLlVhk2fIA

https://cs186berkeley.net/notes/note9/

https://digital-library.theiet.org/doi/10.1049/cp.2013.2004

https://www.geeksforgeeks.org/difference-between-nested-loop-join-and-hash-join/

https://muhammad-sherif.hashnode.dev/query-execution-part-2-join-algorithms-hash-join

http://www.louisemeta.com/blog/explain-3/

https://www.sqlservercentral.com/forums/topic/slow-query-uses-nested-loop-and-clustered-index-seek-but-hint-for-hash-join-is-much-faster

https://itpfdoc.hitachi.co.jp/manuals/3000/30006502h0e/HAPG0085.HTM

https://www.sqlshack.com/internals-of-physical-join-operators-nested-loops-join-hash-match-join-merge-join-in-sql-server/

https://direct.mit.edu/books/edited-volume/2853/chapter/77358/Join-Index-Materialized-View-and-Hybrid-Hash-Join

https://en.ittrip.xyz/sql/hash-vs-nested-loop-sql

https://archive.fosdem.org/2022/schedule/event/mysql_hash_join/attachments/slides/5114/export/events/attachments/mysql_hash_join/slides/5114/hashjoin_fosdem22.pdf

https://www.sqljared.com/blog/hash-match-joins/

https://ask.pingcap.com/t/performance-differences-between-tidb-hash-join-and-nested-join-index-join/2230

https://groups.google.com/g/firebird-support/c/mRj4TgvHAvg

https://tomyrhymond.wordpress.com/2011/10/01/nested-loop-hash-and-merge-joins/

http://ieeexplore.ieee.org/document/113476/

https://infocenter.sybase.com/help/topic/com.sybase.help.sqlanywhere.12.0.0/dbusage/join-methods-optimizer-queryopt.html

https://www.youtube.com/watch?v=EEWp29GL-0A

https://www.madeiradata.com/post/loop-hash-and-merge-join-types

https://jcs.ep.jhu.edu/ejava-javaee/coursedocs/content/html/jpa-tuning-join.html

https://enterprisedb.com/postgres-tutorials/parallel-hash-joins-postgresql-explained?lang=en

https://blog.sqlgrease.com/loop-join-and-hash-join-hints-careful-it-forces-order/

https://eitanblumin.com/2018/10/28/the-loop-hash-and-merge-join-types/

https://mariadb.com/kb/en/block-based-join-algorithms/

https://www.cs.cmu.edu/~natassa/courses/15-721/papers/P26.pdf

https://www.sqlite.org/optoverview.html

https://sql-plsql.blogspot.com/2015/11/difference-merge-join-hash-join.html

https://sqlsunday.com/2013/02/24/join-types-and-performance/

https://cloud.google.com/spanner/docs/query-execution-operators

https://support.quest.com/de-de/technical-documents/sql-optimizer-for-oracle/10.1/user-guide/14

https://jonathanlewis.wordpress.com/2013/09/07/hash-joins/

https://dev.to/mahmoudhossam917/nested-join-vs-hash-join-vs-merge-join-in-postgresql-1ha6

https://issues.apache.org/jira/browse/CALCITE-724

https://www.datacamp.com/doc/mysql/mysql-hash

https://crosscuttingconcerns.com/tag/hash%20join

https://www.linkedin.com/pulse/do-you-know-what-differences-between-hash-join-merge-sql-vosicky

https://bertwagner.com/posts/hash-match-join-internals/

https://www.mssqltips.com/sqlservertip/2115/understanding-sql-server-physical-joins/

https://classes.engineering.wustl.edu/cse530/notes/CSE530A-25-Join-Implementation.pdf

https://facebookincubator.github.io/velox/develop/joins.html

https://help.hcl-software.com/hclinformix/1410/prf/ids_prf_496.html

https://seattledataguy.substack.com/p/back-to-the-basics-with-sql-understanding

https://microsoft.public.sqlserver.programming.narkive.com/7Pxob1r5/hash-match-best

https://postgrespro.com/list/thread-id/2069900

https://www.dbasupport.com/forums/showthread.php?46557-How-can-i-force-optimizer-to-use-hash-anit-join

https://dl.acm.org/doi/10.5555/645475.654167

https://www.couchbase.com/forums/t/hash-join-in-couchbase/34942

https://github.com/timescale/timescaledb/issues/2426

https://www.youtube.com/watch?v=akk2t7G8f4g

https://news.ycombinator.com/item?id=15344964

https://www.dcs.ed.ac.uk/home/tz/phd/thesis/node21.htm

https://www.scribd.com/document/679558567/PostgreSQL-MERGE-JOIN-vs-HASH-JOIN

https://www.postgresql.org/message-id/CAMNsu3ne_LnDGF76ObeauE%3D0Ejhp800Cu%2BAFrs05WjUR9QVgGA%40mail.gmail.com

https://groups.google.com/g/comp.databases.oracle.server/c/gDWVVsTjVwQ

https://mariadb.com/kb/en/hash_join_cardinality-optimizer_switch-flag/

https://knowledge.informatica.com/s/article/487477?language=en_US

https://docs.amd.com/r/en-US/Vitis_Libraries/database/guide/hw_sql_guide.html_6_1?contentId=XmrYr~ijkctMFO05sU6bfQ

https://www.researchgate.net/figure/TID-and-standard-hash-join-performance-in-multi-user-mode-concurrent-OLTP-transactions_fig1_221613640