Home » RDBMS Server » Performance Tuning » Question for List partition
Question for List partition [message #597094] Mon, 30 September 2013 17:22 Go to next message
dba10
Messages: 1
Registered: September 2013
Junior Member
Hi,

Can a table be list partitioned on a column which has only 2 values Null and not null (say not null value is 'Y').
For eg del_ind is a column where values are either 'Y' (40% values) and rest values are null.
The table is huge ~ 50 M where updates on several other columns can happen. Data is inserted only once.

(i) is this column (del_ind) a good candidate for list partition? why or why not?
(ii) if yes then will it supposed to improve performance on select queries where del_id is not null

Please provide your suggestions.
Thanks for your input.
Dk
Re: Question for List partition [message #597095 is a reply to message #597094] Mon, 30 September 2013 17:27 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
50 M is tiny

what prevents you from doing benchmark tests yourself to measure actual performance?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: Question for List partition [message #597096 is a reply to message #597094] Mon, 30 September 2013 17:36 Go to previous message
Lalit Kumar B
Messages: 2411
Registered: May 2013
Location: World Wide on the Web
Senior Member
First of all, you should always mention your DB version at least.

As Blackswan already said 50 M is tiny. You should understand the actual need as to when partition a table. Anyway, if you are unable to decide, and if your DB version is 11g or up, then, you can make use of Partition Advisor. Go to page 10 of the pdf, you will find ample information about the partition advisor.

Regards,
Lalit
Previous Topic: ISSUE IN THE PERFORMANCE
Next Topic: Big table joining
Goto Forum:
  


Current Time: Wed Oct 01 16:42:54 CDT 2014

Total time taken to generate the page: 0.12863 seconds