[IGNITE-4490] Optimize DML for fast INSERT and MERGE

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.8
• Fix Version/s: 2.4
• Component/s: sql
• Labels: iep-1 performance
• Assignee: Alexander Paschenko
• Reporter: Alexander Paschenko
• Created: 23/Dec/16 16:07
• Updated: 19/Dec/17 12:10
• Resolved: 19/Dec/17 08:12

Description

It's possible to avoid any SQL querying and map some INSERT and MERGE statements to cache operations in a way similar to that of UPDATE and DELETE - i.e. don't make queries when there are no expressions to evaluate in the query and enhance update plans to perform direct cache operations when INSERT and MERGE affect columns _key and _val only.

Issue Links

• relates to: IGNITE-6022 SQL: add native batch execution support for DML statements
• relates to: IGNITE-7236 SQL: create tests for optimized INSERT and MERGE operations
• links to: GitHub Pull Request #1387