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?