Views

• Incorporate your frequently required, complicated joins and calculations into a view so that you don’t have to repeat those joins/calculations in all your queries. Instead, just select from the view.
• In views always define selects with named columns.
• Avoid the use of views within views.
• If possible rather implement procedures to get filtered datasets.