Home >  Term: volatile table
volatile table

A table whose cardinality can vary significantly over relatively short periods of time. Compared to statistics collected for non-volatile tables, statistics collected for volatile tables are less likely to represent the actual data in the tables. The optimizer takes this into account when determining access plans involving a volatile table.

0 0

Creator

  • Peteh
  •  (V.I.P) 14225 points
  • 100% positive feedback
© 2024 CSOFT International, Ltd.