Big Data, Database, Memsql, Clickhouse, Algorithmic Trading.
many hours trying to represent an as-of join optimally in SQL until we were finally able to coerce the engine to perform a (relatively) fast MergeJoin. It is not inconceivable that the vendor could add specialized support for the as-of join as a custom operation in the future. All-in-all, MemSQL