Create Table Item_Master
(
barcodeKey int identity(1,1) Constraint PK_barcodeKey Primary Key Clustered

,barcode Varchar(17) null
)
Create NonClustered index IX_barcode On Item_Master (barcode)

sp_helpindex Item_master -- 인덱스 정보

IX_barcode        nonclustered located on PRIMARY barcode
PK_barcodeKey clustered, unique, primary key located on PRIMARY barcodeKey

Inset 1부터 9까지 (단 2은 맨 마지막 insert.)

Insert into Item_Master (barcode) values ('1' )
Insert into Item_Master (barcode) values ('3' )
Insert into Item_Master (barcode) values ('4' )
Insert into Item_Master (barcode) values ('5' )
Insert into Item_Master (barcode) values ('6' )
Insert into Item_Master (barcode) values ('7' )
Insert into Item_Master (barcode) values ('8' )
Insert into Item_Master (barcode) values ('9' )
Insert into Item_Master (barcode) values ('2' )

select * from Item_Master

barcodeKey , barcode

1                    1
9                    2
2                    3
3                    4
4                    5
5                    6
6                    7
7                    8
8                    9

barcodeKey 가 Clustered 이면

 barcodeKey 기준으로 1,2,3,4,5,6,7,8,9 순으로 나와야 하는것 아닌가요.?