Derby
  1. Derby
  2. DERBY-2205

Add means to display more detailed information about indexes

    Details

    • Type: Improvement Improvement
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 10.3.1.4
    • Fix Version/s: None
    • Component/s: Tools
    • Labels:
      None

      Description

      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.

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Unassigned
              Reporter:
              Kristian Waagan
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:

                Development