Someone in the office gave me a paper from Sybase about update
statistics with sampling in 12.5.0.3. I guess in theory it's supposed
to run fater.

I've never heard of someone doing such a thing with this version of
Sybase. Does it actually work? I have many table with tens of millions
of rows for which it might be useful.

On Jan 22, 4:23*pm, Wayne Happ <wayneh... (AT) earthlink (DOT) net> wrote:
I've done it quite a lot - it's useful for the "update index
statistics" form of the command (the sampling is only used for the non-
leading columns of the indexes), and really reduces the amount of
resources necessary. On large tables the histogram distribution when
using sampling (10%, or 5% or even 1% for very large tables) is
usually pretty close to the complete distribution, and so doesn't
really affect query optimization negatively.

Michael