MonetDB has a special column imprints for secondary indexes.
Cannot find the default isolation level. However it supports set the isolation level to be SERIALIZABLE.
MonetDB uses radix partitioned join algorithm in hash join.
The query will be compiled to MonetDB Assembly Language(MAL).
Some other tools are in the citations.