
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
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