First page Back Continue Last page Overview Graphics
File types(4)
Clustered tables:tables physically stored together because they share common columns and often used together.
- related columns are called cluster key
- indexed cluster
- queries retrieve rows over a rang of cluster key values
- clustered tables may grow unpredictably
- hash cluster
- queries retrieve rows based on equality conditions
- clustered tables are static or size determined