Thanks a lot Jeff,
u mean to say if the table has 10Million Records,then partition can add some difference to it ( i mean for the queries based on it).
are there any disadvantages?
when can we opt for Hash partitioning,can u please tell me some of the techniques to speed up queries
thanks,