Archive for the ‘Uncategorized’ Category
-
Views
Thursday, April 24th, 2008
Security
. Create a view with a limited subset of the rows and/or columns
in a table or tables and give the user permission to use the view,
but not the base tables.
Simplicity
. Create a view that combines tables that have complex
relationships so users writing queries do not need to understand the
relationships.
Complex Joins
. Sometimes queries cannot be done […]