Explain the Optimization of data access paths
Optimization is a very significant aspect of any design. The designer must do the followings for optimization:
i) Add redundant associations or remove non-usable existing associations to minimize the access cost and maximize the convenience
ii) Reorganize the order of computational tasks for the better efficiency
iii) Save all derived attributes to ignore re-computation of complicated expressions.