Applications of Secondary Indexes
•Clustered
data
Company(name, city), Product(pid, maker)
Select city
From Company, Product
Where
name=maker
and pid=“p045”
Select pid
From Company, Product
Where name=maker
and
city=“Seattle”
Company 1
Company 2
Company 3
Products of company 1
Products of company 2
Products of company 3