Nice question, I would also like to know this.
Btw, why do you want to create a new partial index which is already covered by a regular index? Do you want to remove that regular index after creating the partial one?
Regards,
Strahinja
On Fri, Nov 22, 2013 at 4:55 PM, Armand du Plessis <adp@xxxxxxx> wrote:
Hey guys,Just a quick general question around index creation.When creating a partial index on a fairly large table (200gb) where an index already exists that would satisfy the partial index criteria would there still be a scan of the entire table or will it use the existing index when creating the new one?Hope the question make sense.
