On Thu, Sep 13, 2012 at 10:33 AM, Tom Lane wrote:
> Bill Martin writes:
>
>> How can I adjust the statistics target of the index?
>
> Just pretend it's a table.
>
> ALTER TABLE index_name ALTER COLUMN column_name SET STATISTICS ...
>
> You'll need to look at the index (eg with \d) to see
barrybr...@sierracollege.edu writes:
> I sometime see my users delete all rows from a table using a command like
> this:
> DELETE FROM customer *;
> The question is: what is the star? Is it a table alias or an
> output_expression?
Neither; it specifies to search the table and its inheritance chi
Jeff Janes writes:
> On Thu, Sep 13, 2012 at 10:33 AM, Tom Lane wrote:
>> Just pretend it's a table.
>> ALTER TABLE index_name ALTER COLUMN column_name SET STATISTICS ...
>>
>> You'll need to look at the index (eg with \d) to see what the name of
>> the desired column is, since index expressions
