General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only