Parallelism in DB Operations (cont)
Parallel scanning
- scan partitions in parallel and merge results
- maybe ignore some partitions
(e.g. range and hash partitioning)
- can build indexes on each partition
Effectiveness depends on query type vs partitioning type
![[Diagram:Pics/parallel/select-partition.png]](Pics/parallel/select-partition.png)
|
![[prev]](icon/prev.gif){kind=icon}
![[next]](icon/next.gif){kind=icon}