Re: if talbe only serveral hundred mb, can partition table prove the performance?

Michael Wu wrote:

> Dear All,
>
> I partition my order table into 4 partition and use range partition,
> I split it into only 1 tablespace, because the db only has 1 external disk
> which have 12 disks with 1 raid5 set.
>
> After I create a new table and insert old order data into new table, I still
> can not fell any speed up from the new table,
> Did I lose some thing to setting? or the partition only suit for very large
> such hundred of GB but not MB?
>
> Please give me a hint.
>
> Thank You Very Much.
>
> Michael Wu
> kuohwa_at_ms21.hinet.net

Insufficient information from which to formulate an answer:

1. What hardware?
2. What operating system?
3. What Oracle version and edition?
4. Indexes?
5. Optimizer?
6. Current statistics with DBMS_STATS?
7. Copy of the SQL statement being executed?
8. Explain Plan?

We can't look over your shoulder.

Daniel Morgan Received on Sat Dec 14 2002 - 23:26:57 CST