| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Tuning a warehouse
We cut the nightly loads in half
by switching from CHOOSE optimizer
mode to ALL_ROWS every night before the loads.
Then after the loads, we switched
back and bounced the database.
ALL_ROWS is optimized for total
throughput and works well for batch
jobs. FIRST_ROWS works better
for forms and other types of interactive
on-line transactions.
We also use table and index partitioning and analyze the key fact table and dimension tables nightly after the loads.
Try to utilize the star schema functionality if you can.
We are using 8.0.4 and Sun Solaris 2.6
on our 150 Gig datawarehouse and
45 Gig datamart.
Received on Wed Nov 29 2000 - 22:20:22 CST
 |
 |