Home » SQL & PL/SQL » SQL & PL/SQL » partitioned table
partitioned table [message #410568] Mon, 29 June 2009 00:43 Go to next message
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 #410572 is a reply to message #410568] Mon, 29 June 2009 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It has to search in all partitions. It uses parallelism if you ask it to do so.

Regards
Michel
Re: partitioned table [message #410907 is a reply to message #410572] Wed, 01 July 2009 00:47 Go to previous messageGo to next message
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,
Re: partitioned table [message #410914 is a reply to message #410907] Wed, 01 July 2009 01:05 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
http://www.oracle.com/pls/db102/search?remark=quick_search&word=PARALLEL&tab_id=&format=ranked

Regards
Michel
Previous Topic: index on a huge table
Next Topic: Conditional SELECT
Goto Forum:
  


Current Time: Tue Feb 18 01:20:22 CST 2025