Oracle Tips and Tricks - How To Make Your Oracle Systems Your Most Valuable
Asset

Oracle Performance Tuning Tactics Part 4: The Role Of Views In High Performance Databases

Introduction
Uses of Views
Optimising Views
    Integrating Views With The Rest Of The Query
    Keeping Views Separate From The Rest Of The Query
Summary
Further Reading

Introduction

This is the 4th article in the series looking at Oracle performance tuning. This month we'll take a look at the role of views, plus their advantages and disadvantages. If you have any questions send them to us and we'll answer them in a future issue. Feedback is also very welcome, please send us your comments - good or bad

Let's very quickly recap the choice of "weapons" you have available to you in your "arsenal" for Oracle performance tuning:-

1. Full table scans
2. Indexes
3. Joins
4. Views
5. De-normalization
6. Oracle Stored Procedures
7. Sub-queries

Topics 1 to 3 have already been covered. Click here to see the role of views in high performance databases

---------------------------------------

Looking for more Oracle tips and tricks ? Subscribe to our ezine today and save hours of blood, sweat and tears tomorrow.

Smartsoft Computing Ltd
Bristol, England
Tel: 0845 0031320

Contact Us

Click here to view our privacy policy .

This site uses woopra.com to gather statistical information about our visitors. View woopra privacy policy .

Oracle is a registered trademark of Oracle Corporation and/or its affiliates. UNIX is a registered trademark of The Open Group in the United States and other countries.

© Copyright Smartsoft Computing Ltd 2001-2009. All rights reserved.

Search for: