If you refer here: https://code.kx.com/q/basics/syscmds/#l-load-file-or-directory
name, without loading any columns into memory
When you are running, \l .t -> you are loading the object as t in root. Thus .Q.qp is showing t as 0
% ls -lrth t
-rw-r--r-- 1 sujoyrak**bleep** staff 40B Sep 17 17:20 v1
-rw-r--r-- 1 sujoyrak**bleep** staff 40B Sep 17 17:20 v2
KDB+ 4.0 2021.07.12 Copyright (C) 1993-2021 Kx Systems
Thanks @sujoy13. What confused me is "directory of a splayed table", which I interpreted as directory
t as in your example.
A follow-up question: what is the real runtime difference between
\l . and
\l t for this particular example? The latter form also maps the table without copying data from disk to memory. By the way
t is layed out on the disk, it is a splayed table...
Tel: +44 (0)28 3025 2242
Tel: +1 (212) 447 6700
Tel: +61 (0)2 9236 5700