>> one of the indexes. If the same columns occur in more than 1 index you need
>> to read them only once. Then you run 1 and only 1 full table scan (FTS), and
>> with the data of the cursor you add an entry into each of the indexes to
>> rebuild. With just 1 FTS you could create all the indexes at once, and
>> speeding up a full reindex task to use little more than the time the FTS
>> takes.
>
> I don't quite understand your request. You have REINDEX TABLE which
> is able to reindex all the indexes of a table one by one, […]
I understood the request as the scan should be factored out, so that
reindexing a table with multiple indexes would cost only one seq scan.
--
Fabien.
