Thanks for the reply reddy
But the thing is thst even if I partition the table on a date.
My queries are not being done on that date attribute. So even if I am able to partition the table on that date still it would help?