davey23uk comment self explainatory. Isn't it ? Create one local and other global index and observe the underlying structures you should be able to figure out.
Local index is @ partition level and indexed based on the partition data only where as global index, indexed on the whole table(all partitions).




Reply With Quote