[
https://issues.apache.org/jira/browse/IGNITE-8383?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vladimir Ozerov updated IGNITE-8383:
------------------------------------
Labels: performance (was: )
> SQL: CREATE INDEX should iterate over data pages rather than PK index
> ---------------------------------------------------------------------
>
> Key: IGNITE-8383
> URL: https://issues.apache.org/jira/browse/IGNITE-8383
> Project: Ignite
> Issue Type: Task
> Components: sql
> Affects Versions: 2.4
> Reporter: Vladimir Ozerov
> Priority: Major
> Labels: iep-19, performance
> Fix For: 2.6
>
>
> See
> {{org.apache.ignite.internal.processors.query.schema.SchemaIndexCacheVisitorImpl#processPartition}}
> method - currently to create an index we iterate over partition tree. This
> leads to additional page reads because we need to dereference index entry.
> Instead it would be more efficient to iterate over data pages directly.
> Note that there are several bad scenarios when this approach may not perform
> well:
> 1) Huge number of overflow pages
> 2) Shared cache groups
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
