Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>I noticed that the update criteria in the view designer defaults to "Key field and modified fields".
>
>I suspect "Key fields only" would be more efficient, because the WHERE clause thus generated would only involve the PK. I use a single field for PK; the same field would appear in the view.
>
>Any comments?
Hilmar,
I have been taught to use Key fields only. I think I started that way when it resolved a memo field issue. Makes sense that it should be the default instead of the way it is now.
Renoir
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