Updated on 2024-12-18 GMT+08:00

VIEW Object Design

Suggestion 2.16: Limiting View Nesting to Three Layers

Impact of rule violation:

  • Too many nested views can lead to unstable execution plans and unpredictable time consumption.
  • The risk of rebuilding objects on which views depend is high and the probability of lock conflicts increases.

Solution:

  • Create views based on physical tables.