Re: Optimizer showing wrong rows in plan

On 03/28/2010 05:27 PM, Tom Lane wrote:
>   This is intentional: the size estimates for a never-yet-analyzed
> table are *not* zero.  This is because people frequently create and load
> up a table and then immediately query it without an explicit ANALYZE.

Does the creation of an index also populate statistics?

Thanks,
     Jeremy