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...

You mean non partition index. I did created cluster index ( non allign) on partition table and after that Partition table became non partition table.

Could you tell me what do you mean by create a non-aligned index on that field. Is there any example.

I used following code:

--------------This took 6 minutes on partition table

use mydb

go

...

Could you tell me how to over come performance issue when using order by clause partition table.I have created couple partition tables with partition indexes and when I ran query...