Re: ANALYZE ONLY

On Tue, 20 Aug 2024 at 07:52, Michael Harris <harmic@gmail.com> wrote:
>   1. Would such a feature be welcomed? Are there any traps I might not
> have thought of?

I think this sounds like a reasonable feature.


>   2. The existing ANALYZE command has the following structure:
>
>      ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, ...] ]
>
>      It would be easiest to add ONLY as another option, but that
> doesn't look quite
>      right to me - surely the ONLY should be attached to the table name?
>      An alternative would be:
>
>      ANALYZE [ ( option [, ...] ) ] [ONLY] [ table_and_columns [, ...] ]
>
> Any feedback or advice would be great.

Personally I'd prefer a new option to be added. But I agree ONLY isn't
a good name then. Maybe something like SKIP_PARTITIONS.