[jira] [Created] (IGNITE-11056) SQL: Create a view with list of existing indexes

[Anton Vinogradov (Jira)]

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)