<<Previous Next>>
Oracle - What is
clusters? - Feb 23, 2010 at 11:00 PM by Rajmeet
Ghai
What is clusters?
Clusters in Oracle contain data of multiple tables that have the
same one or more columns. All the rows from all the tables that
share the same cluster key are stored together.
Example:
Create a cluster name employee with size 512 bytes
CREATE CLUSTER
employee
(department
NUMBER(4))
SIZE 512
STORAGE (initial 100K next
50K);
Create a cluster key:
CREATE INDEX id_employee ON
CLUSTER employee;
After this tables can be added to the
index.
Oracle - What
is clusters? - April 10, 2009
at 11:00 AM
What is clusters?
Clusters group together tables that share
common columns. These tables are often used together.
Also read
What is trigger in oracle?, What are the types of triggers?, How
the triggers are attached to the table?, What are triggering
attributes?..............
The parser scans the statement and breaks it into logical units
such as keywords, identifiers and operators, A query or a sequence
tree is built using the units above. This is done to transform the
source data into the format required by the result set.............
A system privilege is the right to perform an action on any
schema objects of a particular type..............
|
