#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.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks