Re: Challenge: Partitioning is a wrong idea

mikharakiri_nosp..._at_yahoo.com wrote:
> mikharakiri_nosp..._at_yahoo.com wrote:
> > delete from sales_history
> > where txn_date < ...
>
> BTW, what happens if some partition-unaware user issues this
statement
> on a partitioned table? Would it
>
> i. drop the partitions in the range
> ii. truncate them, or
> iii. do "normal" delete from the relevant partitions
>
> ?

Continued. What is the result of this

create table A as
select * from B

where B is partitioned? Is A partitioned or not? Of course I can test it myself, but normally one can guess the right answer to such a question even without running it. And of course going all the way into the trouble answering this question would worth it only if I'm convinced if partitioning itself is a good idea. Until then, I don't even bother checking. Received on Thu Apr 07 2005 - 14:50:56 CDT