Le 7 mars 2015 11:32, "Nicolas Paris" <nipari...@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.
