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. >