Post Author: Jon80
CA Forum: General Feedback
Since querying is more efficient when using keys, I thought I'd update the objects in my universe (right click on object > keys). When i try to select a key manually (as in the case of complex data views using derived sql), the select statement does not seem to be generated correctly.
This happens even though parsing returns no errors. On the other hand automatic detection of keys (on MS SQL 2005) works fine. Any idea how to update the queries manually?