I would like to understand what is the underlying optimization or
performance tweak that kdb+/q is able to extract when we apply key on
one/more columns in the table. Key serves the purpose of helping join 2
or more tables via row to row match using ...