Re: partition and subpartitioning help
which one will preforme good
if the
show status 'handler%'
gave me this
handler_read_next=7 and handler_read_rnd_next=49,08,079
when i partitioned table to_day(cols) with index ( id & timestamp)
i also created table with a partition of month(cols) with index
and i executed the select statement
the show status 'handler%'
show like this
handler_rad_next=20,35,953 and read_rnd_next=7
which one is better?
but the time taken is less for the partition table with to_days(cols),it takes 16.72265(2.8999)to give me the result
and partiton table with month(cols) it take more then the previous like 21.7464(0.1824)to give the result
which is better
Subject
Views
Written By
Posted
3991
May 11, 2011 04:01AM
1592
May 12, 2011 10:45PM
1680
May 18, 2011 06:13AM
Re: partition and subpartitioning help
1762
May 18, 2011 06:26AM
1585
May 18, 2011 11:15PM
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.