Re: CREATE INDEX uses INDEX ?

Le 7 mars 2015 11:32, "Nicolas Paris" <niparisco@gmail.com> a écrit :
>
> Hello,
>
> I wonder if the process of index creation can benefit from other indexes.
>

It cannot.

> EG: Creating a partial index with predicat based on a boolean column, will use an hypothetic index on that boolean column or always use a seq scan on all rows ?
>

Nope, it always does a seqscan.

> Goal is to create partial indexes faster.
>
> Explain command does not work with Create index.
>

You cannot use EXPLAIN on most DDL commands.