Konstantin Orlov created IGNITE-26135:
-----------------------------------------

             Summary: Sql. Support DELETE operation in optimized plans
                 Key: IGNITE-26135
                 URL: https://issues.apache.org/jira/browse/IGNITE-26135
             Project: Ignite
          Issue Type: Improvement
          Components: sql ai3
            Reporter: Konstantin Orlov


As of now, only single-tuple INSERT queries out of all possible DML is mapped 
to an optimized KV-plans. Let's extend support for DELETE-by-primary key 
operations.

Worth to mention that apart of predicate over primary key, the predicate may 
involve another columns. Such queries cannot leverage KV API since they require 
additional conditions to meet.

See {{org.apache.ignite.internal.sql.engine.prepare.KeyValueModifyPlan}} for 
reference.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to