Re: Distributions

Jay Aymond wrote: > > What is the difference in running the following two statements: > > (1) update statistics medium for table xzy distributions only; > > or > > (2) update statistics medium for table xyx (col1) distributions only; > update statistics medium for table xyz (col2) distributions only;> .... > for all columns in the table The results are the same, however, the former command will run in less time, except on a trivial size table, because it only has to read the data once. Art S. Kagel