[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sapdb-general
Subject:    RE: Very Large Tables
From:       "Schroeder, Alexander" <alexander.schroeder () sap ! com>
Date:       2005-01-28 8:38:46
Message-ID: 821039C4C1647A4D9CFEF51CE9B9AC181E279A () dewdfe23 ! wdf ! sap ! corp
[Download RAW message or body]

Hello Robert,
 
> 1. Is there a way to specify the location of a table or an 
> index on to a
> specific volume or set of volumes ( akin a tablespace)?

Not with MaxDB, as tables are usually distributed among the available
data volumes to get most I/O performance. This of course makes more sense
if the volumes refer to physically different devices.

> 2. Are there any performance concerns relating to querying 
> small subsets of
> data from very large tables?

It always depends on the queries and the chosen strategy. If your
query results in the database performing a table scan, then it may
be of course prohibitively expensive. But without specifying what 
your queries will look like, and which indexes you define, it is
impossible to say whether there may be problems with it.

Regards
Alexander Schröder
SAP DB, SAP Labs Berlin



-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=sapdb-general@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]