Posts with #NestedLoop

#NestedLoop

Public posts on X that use #NestedLoop.

Related hashtags

  1. Steven Posnack@HealthIT_Policy
    ┏┓ ┃┃╱╲ in ┃╱╱╲╲ this ╱╱╭╮╲╲ house ▔▏┗┛▕▔ we ╱▔▔▔▔▔▔▔▔▔▔╲ Wash our hands before and after we wash our hands ╱╱┏┳┓╭╮┏┳┓ ╲╲ ▔▏┗┻┛┃┃┗┻┛▕▔
    2530
  2. Franck Pachot@FranckPachot
    Joins can scale and SQL optimizers have great algorithms and data structures. To be efficient, a join must have fast access to the inner table, with a sort or hash structure. An existing one (sharding, index) or built on the fly (in work memory). Let's look at join methods🧵👇
    18335.5K
  3. Franck Pachot@FranckPachot
    @FranckPachot
    If they are not sorted and the join condition is an equality predicate, the smallest is hashed to accelerate the lookup into the inner table. This is a #HashJoin:
    102325
  4. Franck Pachot@FranckPachot
    @FranckPachot
    If there's already a sorted structure for the inner table, like an index, and not a lot of outer rows, the lookup uses the index for each outer row. This is a #NestedLoop:
    103572
  5. Michael A. Stelzner✓@Mike_Stelzner
    I don’t understand why people take screen shots of tweets and post them on Instagram
    20236
  6. Show more posts