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

declare @P1 char(9)

set @P1=' '

SELECT top 1000 a.t_hrea,a.t_bpid,a.t_bprt,a.t_dtbl,a.t_dtrl,a.t_erdt,a.t_lobl,a.t_lorl,a.t_opon,a.t_orno,a.t_pono,a.t_pstc,a.t_rlam,a.t_rlty,a.t_sqnb

FROM dbo.ttdsls421900_par a

WHERE (a.t_orno > @P1) ORDER BY 10,11,15,1,4 OPTION (FAST 5)

--------------This took seconds on non-partition table

use mydb

go

declare @P1 char(9)

set @P1=' '

SELECT top 1000 a.t_hrea,a.t_bpid,a.t_bprt,a.t_dtbl,a.t_dtrl,a.t_erdt,a.t_lobl,a.t_lorl,a.t_opon,a.t_orno,a.t_pono,a.t_pstc,a.t_rlam,a.t_rlty,a.t_sqnb

FROM dbo.ttdsls421900 a

WHERE (a.t_orno > @P1) ORDER BY 10,11,15,1,4 OPTION (FAST 5)

---------------------

If I remove ORDER BY Clause from code and run against partition table it will give same result as non partition table.