Cette page n'est pas encore disponible dans votre langue. Nous nous efforçons d'ajouter d'autres langues. Nous vous remercions de votre compréhension.

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