This is an awesome explanation. @Josh Berkus, you got a new fan.
@themanwiththescarleteye30402 жыл бұрын
I have a similar query plan (as the one at 17:30) but in the bitmap section I have an inner join condition so something like loans.foreign_key = patrons.primary_key. My question is, taking into consideration that the inner node executes first, how would the inner node know with what patrons primary keys to compare (as the first index scan it's not yet executed).
@9ira45 жыл бұрын
Excellent video!
@bahar48133 жыл бұрын
Thank you 🙏🏻 I really appreciate it
@parveenhebbal97734 жыл бұрын
This is an awesome explanation. @Josh Berkus, you got a new fan.