Re: What is the role played by key columns in a keyed table [ query join/performance ] ?

[rocuinneagain]

For optimisations in qsql queries you should look to attributes.

Here applying the unique attribute to the Name column:

q)t3:update `u#Name from t1 
q)\ts do[100000;select from t3 where Name=`Anand] 
64 1808

 

• https://code.kx.com/q/ref/set-attribute/
• https://code.kx.com/q/wp/columnar-database/

 

• https://code.kx.com/q/ref/find/
•  https://code.kx.com/q/ref/equal/