ONLINE: ROXIE ECL (Part 2) - Complex Query Development

Actions Panel

ONLINE: ROXIE ECL (Part 2) - Complex Query Development

ONLINE: ROXIE ECL (Part 2) - Complex Query Development

When and where

Location

Online

Refund Policy

Contact the organizer to request a refund.

About this event

ROXIE ECL (Part 2)- Complex Query Development

Learn how to optimize and organize your ROXIE queries for optimal performance. This class reviews and recommends best practices used in ROXIE development, including INTERFACE, Half Keyed JOINS, LIMIT, superkeys, and package maps.

Class Prerequisites: Students must have attended the Introduction to ECL (Part 1) & (Part 2), Advanced ECL (Part 2), and ROXIE ECL (Part 1) online training courses. 

Topics include:

• Using INTERFACE structures with ROXIE queries• Limiting your ROXIE results (LIMIT, JOIN, CHOOSEN) • Designing queries using multiple datasets• Case insensitive searches• Use of Superkeys in ROXIE queries• Use of package maps for Query organization• ROXIE-specific functions (PRELOAD, ALLNODES, etc.)• ROXIE Post filtering