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
Messages: 1
Registered: September 2013
Junior Member

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.
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
Messages: 26766
Registered: January 2009
Location: SoCal
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:

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: 3174
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.

Next Topic: Big table joining
Goto Forum:

Current Time: Sat Mar 25 06:23:46 CDT 2023