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
I assume it would have to be optional since the columns page can become extremely large and therefore unbearably slow with "large" databases.
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.
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.
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.
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.
Is there a way to get patch?
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.
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,
That is what I was looking for. Thanks John.
Log in to post a comment.