Vladimir Ozerov created IGNITE-8383: ---------------------------------------
Summary: 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 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)