> My boss is interestred in SAPDB. But I don't know how to > optimize huge tables in SAPDB. With ORACLE database we can > use PARTITION TABLE to devide huge tables into small pieces. > What can I do with SAPDB?
SAPDB stores DATA, INDEX and since 7.4 also SYSTEM pages all in the DEVSPACES. There's no such thing like "partitioning" in Oracle since everything is stored an organized by the DB itself. To increase speed make sure you have enough devspaces so that the database will spread the data across them and can read parallely. You don't have any influence on WHERE the data is stored, the DB will organize this automatically. Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus D�hr SAP-CC/BC, SAPDB-DBA Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
