LISTING 1: Create Indexed_Table

create table Indexed_Table
( 
id	int,
non_clustered_index_field	varchar(10),
non_indexed_field	numeric(10),
)
go
create index non_clustered_index on Indexed_Table (non_clustered_index_field)
go