SELECT * FROM SYS.INDEXES
> 22 июня 2022 г., в 18:38, Surinder Mehra <redni...@gmail.com> написал(а):
>
> Hi,
> We have defined indexes on sql enabled ignite cache and are able to see
> indexes being used while querying.
> sqline !indexes also shows those indexes in output. But we cant see default
> index created by ignite on primary key and affinity key.
> We would like to use index on key and affinity key to get results sorted
> accordingly.
>
> For example, in official docs link below, Is it possible to use the above
> mentioned default indexes instead of ORG_SALARY_IDX ?
> How can we get more details about these indexes which are not shown in
> sqlline commands.
>
>
> https://ignite.apache.org/docs/latest/key-value-api/using-cache-queries#executing-index-queries
>
> <https://ignite.apache.org/docs/latest/key-value-api/using-cache-queries#executing-index-queries>
>
> QueryCursor<Cache.Entry<Integer, Person>> cursor = cache.query(
> new IndexQuery<Integer, Person>(Person.class, "ORG_SALARY_IDX")
> .setCriteria(eq("orgId", 1), gt("salary", 1000))
> );
