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
8226
December 03, 2016 11:53AM
2492
December 10, 2016 12:30AM
2299
December 10, 2016 06:48AM
2112
December 12, 2016 01:56PM
2234
December 13, 2016 02:50PM
Re: Count(*) query is slower on partitioned table
2017
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.