We have table called employee and this table doesn't have primary key column. This table contains heavy records and to improve performance of query we are planning to implement Table Partition.
Table structure :
create table employee
( X_Name varchar(10), Sent date, Y_Lastname varchar(5));
We have tried to create Table partition with the column Sent (create secondary files on the basis of date). But this column contains duplicate values and we are not able to create primary key constraint for partition schema.
Please suggest how to create table partition with existing table if table does not have primary key column.
NOTE: we have tried to create new column with the name of ID as a identity and we didn't get any performance improvements by adding new column to existing table.
We are referring below URL to setup Table Partition in our environment.
Thanks in advance.