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
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