Filtered Indexes
create nonclustered index [NC_Index_CA]
on sales.customers
(
[state] asc
)
where state = 'CA'
create nonclustered index [NC_Index_CA]
on sales.customers
(
[state] asc
)
where state = 'CA'
