Re: partition performance

Posted by ErmanArslansOracleBlog on Oct 30, 2022; 6:33pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/partition-performance-tp11168p11176.html

It depends on your workload, queries and partition keys..
Global indexes may provide better performance in OLTP.. They may be faster when fewer index probes are required, when your query need to access data stored in the columns other than the column(s) used in partition key(s).