Help - Search - Members - Calendar
Full Version: Grouping Index Columns
Webyog Forums > SQLyog > SQLyog: Bugs / Feature Requests
gaspo
I'm not sure if this has been mentioned before, but I find viewing indexes a bit confusing, especially with the larger tables with many multi-column indexes.

I think that indexes could be easily organized into tree nodes where index node would have an index name and its children would be index columns. So when I open the Indexes node it will show index names and if I would want to see the index' columns I would open the appropriate index node.
peterlaursen
We simply execute "show indexes from ...". It lists the indexes in aphabetical order.
There is also no appropriate way of doing what you request by querying Information_Schema.

So it is not 'very easy'. We do not get discrete values returned from MySQL - just a long string. So that we would have to parse and organize ourselves.

I also do not think this was requested like this before. However I remember requests that the the 'manage indexes' dialogue should be sortable and resizable.

We will add this request to our tracker, but it will not be high priority (a matter of balancing the effort with the 'value')
navyashree.r
Hi,
Your issue has been added in our list,
http://code.google.com/p/sqlyog/issues/detail?id=728


Thank you.
Regards,
Navya
gaspo
I think I saw this feature in some other program and thought that it would improve the user interface of SQLyog a bit.
Thank you for adding this request to your list.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.