>Hi Dennis!
>
>If your talking about a temporary index your building on a view, the answer is no.
>
>>If I am using an index with a view do I need to also maintain an index for the same field in the data table.
Question, if you are querying the base table off of this field wouldn't it be faster with an index?
Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown