partitioning with date
Hi ,
I had partitioned a table with range partition having the expression 'year(datetime)' also sub partitioned each main partition with a hash partition having expression 'month(datetime)' and tried to access the data in the same table using a select query having a where condition of date range of one year ,the time taken to execute the query is more as compared to the query execution time in another table with same data and having no partition ,also the primary key of the both table are same.
I think partition increases the execution speed of query ,but unfortunately i couldn't achieve it from the above experiment.Is there anything more i have to do in partitioning other than giving the range value and hash values properly . Can anybody help me out in this regard.
Thank You,
Regards
jacob
Subject
Views
Written By
Posted
partitioning with date
3756
February 24, 2009 08:15AM
2345
March 18, 2009 09:19AM
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.