Skip to main content
Submitted by SharonVan on 23 April 2021

September 13, 9:00am - September 14, 5:00pm,  Remote via Microsoft Teams

Note: Due to the continued need for social distancing our instructor-led classes will be held remotely via Microsoft Teams. Switching to the remote format, Part 1 classes will start earlier on Monday (9 AM), and will conclude on Tuesday by 5 PM. When enrolling, please note this time change. Your instructor will send you a welcome email with details on what you will need after enrolling.

This class is for developers who want to extend their knowledge of ECL to developing Roxie queries for end-user use. In this course, you will learn the benefits of payload indexes as well as use of the indexed joins that make query results fast. Anyone planning to write ECL code to provide final product data to end-users should attend this course.

Note: This course is the first in a two-part ROXIE series. People who attend the Roxie ECL (Part 1) – Indexes and Queries class, should also attend the Roxie ECL (Part 2) – Complex Query Development. Both classes are presented in the same week.

Course Length: 2 days

Class Prerequisites: Students must have attended the Introduction to ECL (Part 1) - Concepts and Queries and the Introduction to ECL (Part 2) - the Extract, Transform, and Load (ETL) Process. Students are welcome to bring their own laptops to take away the code and examples from the class.

Topics include:

  • Defining and Creating INDEXes
  • Using FETCH
  • Creating Roxie Queries (STORED)
  • Testing queries in hThor
  • Deploying to Roxie
  • Payload Indexes
  • Full and Half-Keyed JOIN
  • Optimizing Queries (LIMIT, ATMOST, KEEP

Class begins Monday at 9am and concludes at 5pm.
Class begins Tuesday at 9am and concludes at 5pm.

Click to enroll in Part 1. To enroll in Part 2, click on the following link: Enroll in Roxie ECL (Part 2) – Complex Query Development.

RELX and LexisNexis employees should register using the approved promo code provided by their manager. Contact Us if you need assistance.