You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Andrey Mashenkov (Jira)" <ji...@apache.org> on 2021/09/09 15:43:00 UTC

[jira] [Created] (IGNITE-15483) Uniq index detection.

Andrey Mashenkov created IGNITE-15483:
-----------------------------------------

             Summary: Uniq index detection.
                 Key: IGNITE-15483
                 URL: https://issues.apache.org/jira/browse/IGNITE-15483
             Project: Ignite
          Issue Type: Improvement
            Reporter: Andrey Mashenkov


Uniq index constraint support is very limited due to performance issues in the general case.
Uniq index must contain all affinity columns, in this case, uniqueness achieves out of the box and costs nothing.

Uniq flag is very useful in query planning, as we may rely on the fact the unique index lookup will always return a single row.

Maybe, it is not a good idea to allow users to configure index "uniq" flag manually. (this is discussable)
But we can detect unique index and set the flag automatically.




--
This message was sent by Atlassian Jira
(v8.3.4#803005)