Depending on your application you can actually create your own
partitioning. For example, we have a database here where we create
a new tablespace and tables every month to deal with that months
data. We have some set views that combine certain months together.
I would say that if you can parti
Hi Bruce,
Manual striping is great for parallel query. See "Disk Configuration for
Parallel Table Scans" at
http://www.ixora.com.au/tips/creation/parallel_table_scans.htm for why.
The RevealNet tip is probably motivated by a desire to avoid read/write lock
contention. Temporary tablespace datafi
Hi,
We have a number of large tables that we want to increase the performance of
queries against.
This will be using 8171 on NT utilising the Parallel query option (PQO) on a
server with 4 CPUs.
Ideally we would like to partition the tables but due to the cost of the
partitioning option (hundre