In a partitioned table, what is the difference between a local index and a global index. Is there a advantage/disadvantage in choosing one against the other?