It is exceedingly difficult to get an overview of create, delete and sort options in the relationship graph. A little traffic light to indicate the three options would be very easy and appealing
- red - cascade delete
- yellow - sort
- green - create
OK - so the "yellow" color needs changing - but you get the idea!
Also desirable is a tooltip with details of the sort order.
- Find erroneous relations quicker
- Low impact / high information GUI artifact
- Making databases ☺
- Finding cascading deletes (which can cause problems if the cascading delete is to an ESS table or invalid file)
- Tuning database performance: Moving sorting off relations and onto portals, or creating non-sorted relations for faster processing