• Aligned index (separate indexes split by partition):

    create index ix_pt_index on partitioned_table (indexed_value)

    ON [ps_PartitionScheme](partition_key) --Name of partition scheme

    Non-aligned index (one index that covers all values across all partitions):

    create index ix_index on partitioned_table (indexed_value)

    ON [FG_Index] --Name of filegroup