Skip to Content
0
Former Member
Dec 02, 2007 at 01:55 PM

Keys

16 Views

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?