Download the slides below.You can watch the full recording here.Feel free to ask any questions you have here. Aggregate and generate real-time reports on OLTP data with zero impact to OLTP applications and without polluting buffer pool with expensive analytic queries. Other use cases include 1) Data transformations 2) Update external systems like MQTT, Hadoop and Graph databases 3) Replicate data for tables that do not have primary key, unique index or ER key.
Common Table Expressions (CTE) are a SQL standard feature, CTE simplify queries and make queries more readable. Use recursive CTE to query hierarchical data, and tree/graph structured data. Also, you can do programming tasks with CTE.
Join this session to hear more about and see a demo with Informix 14.10 release support of: