
use credit
go

sp_helpindex 'dbo.member'
go

create index memberlastname on member(lastname)

select count(*) from member

select * from member
where lastname like 'Beau%'

select * from member
where lastname like '%Beau%'

select * from member
where lastname like '%u%'

create index fnameidx on member(firstname)
go

select * from member
where firstname like '%dm%'
go

