|Subject||Re: [IB-Architect] Index Sync/Rebuild Question|
> In addition, there is ALTER INDEX <indexname> SELECTIVITY which performsI was going to mention this earlier but, forgot to.
> an online, non-destructive traversal of the leaf level to recompute
> index selectivity. This feeds back into the query optimizer's
The syntax is actually a tad bit different than
pg. 148, 5.5 Lang Ref.
SET STATISTICS INDEX <index_name>
It says: For tables where the number of duplicate values
in indexed columns radically increases or decreases,
periodically recomputing index selectivity can
NOTE: SET STATISTICS does _not_ rebuild an index.