partitioned table [message #410568] |
Mon, 29 June 2009 00:43  |
behi
Messages: 12 Registered: June 2009
|
Junior Member |
|
|
Hi all,
I made a partitioned table with a date column as the partitioning key. But, I have a query requesting this table for a different column. In this case, how oracle manages this query? does oracle search the whole partitiones in parallel or in sequence(partition by partition)?
Many thanks
|
|
|
|
Re: partitioned table [message #410907 is a reply to message #410572] |
Wed, 01 July 2009 00:47   |
behi
Messages: 12 Registered: June 2009
|
Junior Member |
|
|
Thanks Michel, but how should I define for oracle to use parallelism? Meanwhile, what is the effect of this parallelism on DB performance?
Regards,
|
|
|
|