Ever seen a table with so many columns you wonder if the designer had fallen out of the de-normalization tree and had hit every branch on the way down? Oracle currently allows a max of 1,000 columns per table. Please do not test this limit. Maybe you do need that many columns, but I doubt it.
If you were to visualize this data model, imagine how easily you might be overwhelmed with all the white-noise, or extra information.
In an earlier post I advocated using SubViews to alleviate the headaches you get when working with many hundreds or thousands of entities.
Well maybe you only have several dozen entities but the number of attributes is overwhelming.
So just hide them
A new feature in v3.1 – now in Early Adopter Release – allows you to auto-hide attributes that don’t meet the following requirements:
The Goldilocks View
After you apply the model view options, the ‘extra’ attributes/columns will be hidden. However, the entity objects in the diagram will still be REALLY big. So just right-mouse-click and use the ‘Resize objects to visible’ call.