[
https://issues.apache.org/jira/browse/IGNITE-11056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-11056:
---------------------------------------
Description:
We need to create a SQL system view of currently available SQL indexes.
It should contains the following information:
# Schema name
# Table name
# Index name
# Index key - String with columns included into the index with information
about collation
# Cache id
# Cache name
# Group id
# Group name
# Inline size
#
Starting point: {{SqlSystemView}}
was:
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}}
> 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
> Priority: Major
> Labels: iep-29
> Fix For: 2.8
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> We need to create a SQL system view of currently available SQL indexes.
> It should contains the following information:
> # Schema name
> # Table name
> # Index name
> # Index key - String with columns included into the index with information
> about collation
> # Cache id
> # Cache name
> # Group id
> # Group name
> # Inline size
> #
> Starting point: {{SqlSystemView}}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
