Home » SQL & PL/SQL » SQL & PL/SQL » partition type selection (9i,windows 2003 server)
partition type selection [message #326276] Tue, 10 June 2008 23:34 Go to next message
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.
Re: partition type selection [message #326277 is a reply to message #326276] Tue, 10 June 2008 23:37 Go to previous messageGo to next message
BlackSwan
Messages: 25033
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!
Re: partition type selection [message #326279 is a reply to message #326277] Tue, 10 June 2008 23:43 Go to previous messageGo to next message
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.
Re: partition type selection [message #326280 is a reply to message #326276] Tue, 10 June 2008 23:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
arunshrish wrote on Tue, 10 June 2008 21:43
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.

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 Go to previous messageGo to next message
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??
Re: partition type selection [message #326285 is a reply to message #326281] Tue, 10 June 2008 23:57 Go to previous messageGo to next message
arunshrish
Messages: 74
Registered: May 2008
Location: Chennai
Member
@ Ana,

Ok thanks Ana.
Re: partition type selection [message #326288 is a reply to message #326276] Wed, 11 June 2008 00:02 Go to previous message
flyboy
Messages: 1832
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:
  


Current Time: Fri Dec 02 14:20:33 CST 2016

Total time taken to generate the page: 0.08778 seconds