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
7525
December 03, 2016 11:53AM
2295
December 10, 2016 12:30AM
2114
December 10, 2016 06:48AM
1963
December 12, 2016 01:56PM
2048
December 13, 2016 02:50PM
Re: Count(*) query is slower on partitioned table
1859
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.