You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Kristian Waagan (JIRA)" <ji...@apache.org> on 2007/01/03 17:34:27 UTC

[jira] Created: (DERBY-2205) Add means to display more detailed information about indexes

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