RE: How indexes and tables are stored
"Dittmar, Daniel" <[email protected]> Thu, 17 Apr 2003 16:35:28 +0200
| Newsgroups | gmane.comp.db.sapdb.sources |
|---|---|
| Message-ID | <B9A2DDA03044D311BBD40008C75D6968147D863B@dewdfx24> |
> I want to now what the indexes and tables are stored in sapdb > devspaces ? > > If i have 3 disks, /hda, /hdb, /hdc. > > I want : > > /hda ---> sapdb programs. > /hdb ---> table data. > /hdc ---> index data > > To make posible paralel access to de indexes and tables. SAP DB sees the combination of all data devspaces as one large memory space. New pages are allocated from devspaces that have fewer pages allocated. This means that the database will distribute I/O over the devspaces automatically. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [email protected] http://www.sapdb.org/