« How can I experiment on a production kdb while keeping the data free from accidental damage? | Main | What is the difference between the functions xcol and xcols? »

What is a virtual column?

A virtual column is not stored. There are two kinds of virtual columns in kdb:

  1. The index column, i, which is present in all tables, and
  2. the partition column on a partitioned table. For example, the most common partitioning scheme is by date. Rather than storing the date column along with the other columns in the table, the date is inferred from the partition directory; splayed table directories will not contain files for the date column.

See also: .Q.pf and .Q.pt

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Textile formatting is allowed.