Re: Pruning problem.
Posted by: Rick James ()
Date: September 23, 2010 08:40AM
Ok, your table will be big enough to consider partitioning. But you have not presented a SELECT that will benefit from partitioning. Nor have you mentioned the one big use of partitioning -- efficient pruning of old data.
|Pruning problem.||2160||Vladimiro Puggelli||09/21/2010 04:03AM|
|Re: Pruning problem.||1111||Rick James||09/22/2010 07:57PM|
|Re: Pruning problem.||1187||Vladimiro Puggelli||09/23/2010 03:16AM|
|Re: Pruning problem.||1132||Rick James||09/23/2010 08:40AM|
|Re: Pruning problem.||1061||Vladimiro Puggelli||09/24/2010 02:24AM|
|Re: Pruning problem.||1205||Mattias Jonsson||09/28/2010 10:38AM|
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.