Add means to display more detailed information about indexes
------------------------------------------------------------
Key: DERBY-2205
URL: https://issues.apache.org/jira/browse/DERBY-2205
Project: Derby
Issue Type: Improvement
Components: Tools
Affects Versions: 10.3.0.0
Reporter: Kristian Waagan
Derby does not have a convenient mean to show detailed information for indexes.
"SHOW INDEXES" is available in ij, but the information it shows is
inaccurate/insufficient.
For instance, it is impossible to determine which composite indexes you have on
a table and the order of the columns in the index.
Sample output from a database with two tables (one unique, one primary, one
foreign key and one composite index):
ij> show indexes in app;
TABLE_NAME |COLUMN_NAME |NON_U&|TYPE|ASC&|CARDINA&|PAGES
----------------------------------------------------------------------------
DUMMYFKS |FK |false |3 |A |NULL |NULL
INDEXTEST |COLA |false |3 |A |NULL |NULL
INDEXTEST |COLA |true |3 |A |NULL |NULL
INDEXTEST |COLB |true |3 |A |NULL |NULL
INDEXTEST |COLB |true |3 |A |NULL |NULL
5 rows selected
The only information about composite indexes I have found, is the field
DESCRIPTOR in SYS.SYSCONGLOMERATES. The values are generated by
IndexDescriptorImpl.toString().
Further, the names of the indexes are not shown when using SHOW INDEXES.
Displaying the name would make sense, especially for user-defined (non-backing)
indexes. It would also be necessary if we want to keep the "one index column
per row/line" presentation (does this originate from the JDBC
DatabaseMetaData.getIndexInfo-method?).
If there are more information about indexes available, we should consider
if/how we want to present it to the user.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
