OraFAQ Forum: SQL & PL/SQL » partition type selection

Home » SQL & PL/SQL » SQL & PL/SQL » partition type selection (9i,windows 2003 server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

partition type selection [message #326276]

Tue, 10 June 2008 23:34

arunshrish
Messages: 74
Registered: May 2008
Location: Chennai

Member

Hi all,
I have a very generalised question in my mind..If we are given a big table to partition so as to improve the performance,what all factors have to be considered in order to select a particular type of partition...(is there any partition type thatis known to improve the performance considerably?)

Thanks,
Arun.

Report message to a moderator

Re: partition type selection [message #326277 is a reply to message #326276]

Tue, 10 June 2008 23:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>...(is there any partition type thatis known to improve the performance considerably?)
NO, or there would only 1 partition type; the one that always worked!

Report message to a moderator

Re: partition type selection [message #326279 is a reply to message #326277]

Tue, 10 June 2008 23:43

arunshrish
Messages: 74
Registered: May 2008
Location: Chennai

Member

Hi Ana,
Many Thanks for the reply...what about this question (what all factors have to be considered in order to select a particular type of partition??)..can u pls give me some tips for this ?

Regards,
Arun.

Report message to a moderator

Re: partition type selection [message #326280 is a reply to message #326276]

Tue, 10 June 2008 23:44

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The first question is "will partitioning improve the performances?".

Regards
Michel

[Updated on: Tue, 10 June 2008 23:45]

Report message to a moderator

Re: partition type selection [message #326281 is a reply to message #326279]

Tue, 10 June 2008 23:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

arunshrish wrote on Tue, 10 June 2008 21:43

If partitioning ALWAYS fixed problem {your specified} here, then Oracle would have automagically implemented it.

There are NO magic/silver bullets that ALWAYS work.

[Updated on: Tue, 10 June 2008 23:53] by Moderator

Report message to a moderator

Re: partition type selection [message #326283 is a reply to message #326280]

Tue, 10 June 2008 23:55

arunshrish
Messages: 74
Registered: May 2008
Location: Chennai

Member

@ Michel,

Hi thanks for reply, recently I tested doing a hash partition on a table of around million rows i found the queries accessing the table reacted just 1 second faster than before ...so really there is no significant improvement as you said....well can u suggest me some other methods that might improve the performance??

Report message to a moderator

Re: partition type selection [message #326285 is a reply to message #326281]

Tue, 10 June 2008 23:57

arunshrish
Messages: 74
Registered: May 2008
Location: Chennai

Member

@ Ana,

Ok thanks Ana.

Report message to a moderator

Re: partition type selection [message #326288 is a reply to message #326276]

Wed, 11 June 2008 00:02

flyboy
Messages: 1903
Registered: November 2006

Senior Member

> what all factors have to be considered in order to select a particular type of partition??
All queries (select/insert/update/delete) in which the table is involved and the impact of partitioning on them.

> well can u suggest me some other methods that might improve the performance??
I am afraid it is impossible as you did not post table structure with the queries (or at least the releveant testcase).
But, as your question is general, I will answer you in general too: study Performance Tuning Guide book, found e.g. on http://download.oracle.com/docs/cd/B10501_01/server.920/a96533/toc.htm

[Edit: Added last sentence]

[Updated on: Wed, 11 June 2008 00:26]

Report message to a moderator

Previous Topic:	indexing materialized view - resource busy error
Next Topic:	sql query not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jul 19 03:09:58 CDT 2025