How does CONNX perform joins?
CONNX has a distributed SQL Engine that will examine several factors when performing joins. CONNX uses the following four major factors to determine the best way to process joins: 1) Join Direction (Left outer Joins, or Right outer Joins) 2) Indexes available on tables in query that match criteria columns 3) Indexes available on tables in query that match join columns 4) Table cardinality The CONNX SQL Engine analyzes this data to determine the best way to process the query. This is done dynamically for each query executed.
