for example when I creted cluster index, partition table lost the partition scheme and becomes non partion.

And when I created just the non cluster index , execution plan doesnt take this index and keeps go to sort 92%.

Thanks