RE:How to make Partition for mytable

[venkat puvvada]

Hi all,
This is venkat,i would like to share my problem here,my problem is
I Have a table which is having more then 70 million records,and it will update daily with 1milion records.when we are doing partition based on the primary key for my table [3 primary key fields,one filed used for partition which is of type date] we are not getting good result because the fields which we are using in the query not a part of the partition fields .
can any one suggest me how to resolve this case because we have lot query's,it is very difficult to change all the query's,please help me how to make partition fo r this case.

thanks,
venkat p



Edited 2 time(s). Last edit at 04/12/2011 11:47PM by venkat puvvada.