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