Advanced ROXIE - Complex Query Development
Learn how to optimize ROXIE queries for optimal performance.
Course Length: 2 days
Class Prerequisites: Students must have attended the Introduction to ECL, Introduction to Thor, and Introduction to Roxie Training classes. Students are welcome to bring their own laptops to take away the code and examples from the class.
- ROXIE-specific functions (PRELOAD, ALLNODES, etc.)
- Complex Compound INDEXes (Phonetics, skipping based on cardinality)
- Relating to seeks and scans in the graph
- Non-blocking activities
- GROUP function
- In-memory datasets
- Post filtering
When & Where
HPCC Systems® (www.hpccsystems.com) from LexisNexis® Risk Solutions offers a proven, data-intensive supercomputing platform, designed for the enterprise, to process and solve Big Data analytical problems. As an alternative to legacy technology, HPCC Systems offers a consistent data-centric programming language, two processing platforms and a single, complete end-to-end architecture for efficient processing.