Keyed Table Mechanics

Community Support
,
1

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?

2

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.