db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristian Waagan (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2205) Add means to display more detailed information about indexes
Date Wed, 03 Jan 2007 16:34:27 GMT
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

        

Mime
View raw message