Re: Count(*) query is slower on partitioned table
Posted by:
Rick James
Date: December 21, 2016 12:35AM
By the time you are finished, each row is considerably wider than when you started. Bigger rows -> fewer per block -> slightly slower.
Probably the only difference between 30 and 1000 in your example is 1-byte versus 2-byte length field for that column.
Subject
Views
Written By
Posted
7923
December 03, 2016 11:53AM
2417
December 10, 2016 12:30AM
2227
December 10, 2016 06:48AM
2051
December 12, 2016 01:56PM
2160
December 13, 2016 02:50PM
Re: Count(*) query is slower on partitioned table
1941
December 21, 2016 12:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.