Optimizing Nested Loop joins on YugabyteDB with jOOQ

• yugabyte-db

  87 8,486 10.0 C

  YugabyteDB - the cloud native distributed SQL database for mission-critical applications.

  

Result result = ctx .select() .from(p) .join(d).on(p.PRODUCT_ID.eq(d.PRODUCT_ID)) .where(p.UNIT_PRICE.gt(50.f)) // workaround: add a subquery returning a list of PRODUCT_ID: .and( d.PRODUCT_ID.in ( ctx.select(p.PRODUCT_ID).from(p) .where(p.UNIT_PRICE.gt(50.f)) .fetch(p.PRODUCT_ID) ) ) // this workaround will not be needed when https://github.com/yugabyte/yugabyte-db/issues/4903 is solved .fetch();

• jOOQ

  94 5,882 9.8 Java

  jOOQ is the best way to write SQL in Java

  

If you use jOOQ, everything about SQL becomes easier to code and the barrier between dynamic and static SQL is small as all are typesafe.

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project