https://learninghub.kx.com/forums/topic/keyed-table-mechanics
Why does the select function store the values of kt out of order with respect to the values of t?
https://learninghub.kx.com/forums/topic/keyed-table-mechanics
Why does the select function store the values of kt out of order with respect to the values of t?
The values aren’t stored out of order. As the ID column is acting as a foreign key, the corresponding v values to each ID from the kt table are as follows:
ID v 1002 200 1001 100 1003 300 1001 100
That’s why they appear in the order they do in the select query. Hopefully that’s clear enough.