On Fri, Dec 27, 2019 at 3:26 PM Zhihong Zhang <zhihong(at)gmail(dot)com> wrote:
> Finally got stats on the new table assets_copy. Still don’t know what’s
> the magic. I have 2 indexes in this new table, only this one got stats.
>
Only one of your indexes is over an expression. The index over a plain
column will never have stats, as column stats are stored with the table,
not the index.
Cheers,
Jeff