Re: tables with no indicies

Bridget Reitsma wrote: > > I was asked to post this on behalf of a collegue of mine - thanks for > all your replies and excellent help! > > For tables with no indices (I always expect to scan a majority of > rows), is > there any point to using a mode other than low for update statistics? If > so, > why? The tables in question are spread over multiple dbspaces. > > regards Bridget If you have no indexes there is not much to be gained from update stats at any level. If you do many joins the UPDATE STATISTICS MEDIUM/HIGH may help the optimizer decide whether to create a dynamic index or a hash table. Art S. Kagel