Not sure if I understand your question correctly, but you create an Index based on the attribute that you want to use for partitioning. For instance, if you are planning to archive or move data based on order date, your Index for the partitioning should be based on the order date attribute.

Gail has a very nice article about partitioning and query performance[/url] It may not answer your question directly but will go more in detail about the process.