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.