Re: SAP R3

>I wonder if other peole have realised, that SAP/R3 stores all the attributes of
>one row in ONE db-attribute (does'nt matter if it is oracle, sybase, ...).
>
>So, nobody has any possibility to tune a DB-System (for example to set an
>index) or to use any other product to select SAP/R3 attributes (without copy
>SAP/R3 tables to normal DB-tables) like SQL or other products like Business
>Object, Access, Forms...
>
>Any experiences?
>
>Stefan Wagner
>

Well we did not try. After a bit of investigation it became obvious that SAP was using the underlying database as basically a file system. Any thing defined in the SAP data dictionary can not be tuned. (That includes table placement, indexes and all those other things that you normally would use for tuning :-( )

Garth

+----------------------------------------------------------------+
| Garth Kennedy     garth_at_comm.mot.com  Telephone (708) 576-3786 |
| Radio Network Solutions Group Motorola      FAX (708) 576-2656 |
+----------------------------------------------------------------+

-- 
+----------------------------------------------------------------+
| Garth Kennedy     garth_at_comm.mot.com  Telephone (708) 576-3786 |
| Radio Network Solutions Group Motorola      FAX (708) 576-2656 |
+----------------------------------------------------------------+