| Question for List partition [message #597094] |
Mon, 30 September 2013 17:22  |
 |
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 #597096 is a reply to message #597094] |
Mon, 30 September 2013 17:36  |
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.
Regards,
Lalit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
