the vast majority of the fields are varchar(50). the ids are decimal(18).

i have yet to find a nice simple tutorial on creating an indexed view. any recommendations?

thanks.