>>>yes and it made the date query a bit better.
>>>The name query however is still terrible. The name field is c40_01 and I created a tag in the same way on the server drive, but its still very very slow.
>>>
>>>There isnt anyting I need to do to the views AFTER creating the tags is there?
>>>
>>>CG
>>>
>>
>>
>>You can try using SYS(3054, 11) to see if the tags are being used when the view is queried.
>
>I put a button on the form and did a ? sys(3054,11) after the local view refreshed and it said "SQL Showplan is enabled with joint optimization".
>
>CG

Open the view after you issue SYS(3054, 11).

FYI, SYS(3054) is documented in the help file.