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 Novikov (Jira)" <ji...@apache.org> on 2024/02/01 03:17:00 UTC

[jira] [Updated] (IGNITE-21416) Add documentation for FORCE_INDEX/NO_INDEX hints

     [ https://issues.apache.org/jira/browse/IGNITE-21416?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrey Novikov updated IGNITE-21416:
------------------------------------
    Priority: Minor  (was: Major)

> Add documentation for FORCE_INDEX/NO_INDEX hints
> ------------------------------------------------
>
>                 Key: IGNITE-21416
>                 URL: https://issues.apache.org/jira/browse/IGNITE-21416
>             Project: Ignite
>          Issue Type: Improvement
>          Components: documentation, sql
>            Reporter: Andrey Novikov
>            Priority: Minor
>              Labels: ignite-3
>
> Globally it works the same way as in [https://ignite.apache.org/docs/latest/SQL/sql-calcite#force_index-no_index], but has some difference when FORCE_INDEX and NO_INDEX used together in the same query. When both hints reference to the same index {{SELECT /+ FORCE_INDEX('idx'), NOINDEX */, {{SELECT \{*}/{*}+ NO_INDEX(TBL1_IDX2), FORCE_INDEX(TBL2_IDX2) */, ...}} -}} it is invalid case. SQL is declarative language and we shouldn't expect {{hints}} collection is ordered.
> We need to fix example section and rewrite "Hint Scope" section.



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