Jethro Blog
SQL-on-Hadoop, BI-on-Hadoop, Big Data, Interactive Business Intelligence, SQL Query Acceleration and Everything in between.
![logo_jethro_header_teal](https://info.jethro.io/hubfs/Jethro%20-Feb2018/images/logo_jethro_header_teal.png)
Create Join Index
Creates a new join index for a given dimension column and a fact table. The dimension join key must be a PRIMARY KEY for the dimension table.
![](https://info.jethro.io/hubfs/Imported_Blog_Media/join_indexes_diagram_a.jpg)
Join Indexes in Jethro 1.2.0
The brand new Jethro 1.2.0 release packs another powerful performance feature called Join Indexes. Join indexes accelerate performance of join queries with where clause on a dimension value. Combined with Jethro star transformation optimization, join indexes ensure that Jethro uses the most...