Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

VIEW Object Design

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

Suggestion 2.16: Limiting View Nesting to Three Layers

NOTE:

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.
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback