Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#75 Index name is required

open
nobody
None
5
2011-01-24
2011-01-24
ABD01
No

I think, it is a feature requests however don't know how to submit or reach out right person.

Index section under table report should print the "Index Name" along with "Column(s), Type, & Sort)

My DB: Oracle 11G

Discussion

  • John Currier
    John Currier
    2011-01-25

    I assume it would have to be optional since the columns page can become extremely large and therefore unbearably slow with "large" databases.

    John

     
  • ABD01
    ABD01
    2011-01-25

    Anything works for me. The tool is extremely helpful.

    The tool is already pulling the list of columns belongs to an index, so there shouldn't be any performance issue (same DB dictionary table), at least for Oracle & MySQL DB.

     
  • ABD01
    ABD01
    2011-01-25

    I was able to generate ER model report for a schema containing 346 tables and 2 views in about 86 sec. I will be happy if the reports come back within 10 min or so.

     
  • John Currier
    John Currier
    2011-01-25

    I was referring to how long it takes to load and render the page when the database is large (e.g. 20,000+ columns). I stripped a lot of details from the columns page to keep browsers from crashing when trying to load those.

    John

     
  • ABD01
    ABD01
    2011-01-25

    Got it. Thanks.

    Most of the databases are small to mid size, 100-200 tables with less than 1000 columns. Any of the solution would be fine however prefer to print Index Name by default without any parameters.

    Thank your for excellent work.

     
  • ABD01
    ABD01
    2011-01-26

    Is there a way to get patch?

     
  • John Currier
    John Currier
    2011-01-26

    I'll have to implement it first. Unfortunately I'm at NASA for the next few weeks so I don't have much spare time.

     
  • John Currier
    John Currier
    2011-02-22

    As I was working on this I realized that I completely mis-read what you were asking for. I really need to learn to read things more closely before I interpret what I'm reading.

    At the top of the page the table detail page there should be a "Constraints" check box. If you enable constraints you should see the names associated with the index.

    Sorry about my inability to comprehend what I'm reading,
    John

     
  • ABD01
    ABD01
    2011-02-22

    That is what I was looking for. Thanks John.