Table Indexes Tablespaces Oracle Tips by Burleson Consulting

The Data Warehouse Development Life Cycle

Oracle Features for the Data Warehouse

Summary

Now that we have explored the internals of Oracle tables, indexes and tablespaces, let’s take a look at how distributed data warehouses are designed using Oracle SQL*Net. We will then proceed to explore Oracle utilities, Oracle locking and the tuning of Oracle SQL.

---

This is an excerpt from "High Performance Data Warehousing", copyright 1997.

If you like Oracle tuning, you may enjoy the book Oracle Tuning: The Definitive Reference , with over 900 pages of BC's favorite tuning tips & scripts.  You can buy it directly from the publisher and save 30%, and get instant access to the code depot of Oracle tuning scripts.