RE: Performance of multi datafile tablespaces

2001-05-03 Thread Kimberly Smith
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

Performance of multi datafile tablespaces

2001-05-02 Thread Reardon, Bruce (CALBBAY)
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