Hi , I have a table which is having 130Million records(Not partitioned) based on every week. This is what i did .. 1. Created PF(Function) 2. Created PS(Schema) ON FILE GROUP ( consisits of 10 physical files) 3. Created CLUSTERED index on PS . When I did SelecT * From sys.partitions It is showing rows in each partition. I have indexid=1 for all partitions . that means is my index is not partioned ? How do I achive the partitioned index on each of partition??