drop table tbl
go
CREATE TABLE [dbo].[tbl] (
	[num] [int] IDENTITY ( 1 ,  1 ) NOT NULL ,
	[fld1] [int] NOT NULL ,
	[asd] [char] ( 50 ) COLLATE Cyrillic_General_CI_AS NULL 
) ON [PRIMARY]
GO


declare @i int
declare @t varchar( 50 )
set @i= 1 
while(@i< 25000 )
begin
	set @t=Replicate(Convert(nvarchar( 10 ),@i), 4 )
	insert into tbl(fld1,asd) VALUES (@i,@t)
	Set @i=@i+ 1 
end
go

ALTER TABLE [dbo].[tbl] WITH NOCHECK ADD 
	CONSTRAINT [PK_tbl] PRIMARY KEY  CLUSTERED 
	(
		[num]
	)  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_tbl] ON [dbo].[tbl]([fld1]) ON [PRIMARY]
GO


create view vw1 as select fld1 from tbl
go
create view vw2 as select top  100  percent fld1 from tbl order by fld1 
go
select fld1 from vw1 where fld1 between  23  and  60  order by fld1
 -- сортироваться будут только выбранные значения....
 
select fld1 from vw2 where fld1 between  23  and  60  
 -- сортируются все данные из vw2 и только потом фильтруются