Yury Gerzhedovich created IGNITE-11056:
------------------------------------------
Summary: SQL: Create a view with list of existing indexes
Key: IGNITE-11056
URL: https://issues.apache.org/jira/browse/IGNITE-11056
Project: Ignite
Issue Type: Task
Components: sql
Reporter: Yury Gerzhedovich
Assignee: Yury Gerzhedovich
Fix For: 2.8
We need to create a SQL system view of currently available SQL indexes.
It should contains at least:
# Schema name
# Table name
# Index name
# Collation (ASC or DESC)
Potential information which could be included into the view:
# Owning cache ID
# number of columns at the index
# query parallelism
# inline size
# is affinity
# is pk
# approx recommended inline size
List of columns could be as part of the view as columns with sequence of id
such columns or exposed as separate view.
The ticket will be updated after discussion on dev list.
Starting point: {{SqlSystemView}}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
