Regular Views In oracle

Regular Views
A regular view, or more commonly referred to as a view, is not allocated any storage; only its
definition, a query, is stored in the data dictionary. The tables in the query underlying the view
are called base tables; each base table in a view can be further defined as a view.

Clustered Tables in Oracle

Clustered Tables
If two or more tables are frequently accessed together (for example, an order table and a line item
detail table), then creating a clustered table might be a good way to boost the performance of
queries that reference those tables. In the case of an order table with an associated line-item detail
table, the order header information could be stored in the same block as the line-item detail

Oracle Logical Storage Structures

Oracle Logical Storage Structures
The datafiles in an Oracle database are grouped together into one or more tablespaces. Within
each tablespace, the logical database structures, such as tables and indexes, are segments that are
further subdivided into extents and blocks. This logical subdivision of storage allows Oracle to
have more efficient control over disk space usage. Figure 1-2 shows the relationship between the
logical storage structures in a database.
Tablespaces