Hello all, I have some questions relating database sizing:
1. What is the storage consumption of a primary key? 2. What is the storage consumption of indexes? - index on an INTEGER column -index on a VARCHAR column - index on a composite unique key (e.g. VARCHAR + INTEGER or INTEGER + INTEGER) 3. If I know (approx.) the size of the changes on the data devspace is there estimation formula to get the (approx) size of the log devspace? Which database parameter is to be set to define the backup cycle of the log? 4. How does the increase of the system devspace depend (approx.) on the increase of the data devspace? If I know (approx.) the maximum size of the data devspace is there estimation formula to get the (approx) maximum size of the system devspace? 5. The documentation says it is recommendable to split the whole log area in several log devspaces. Is there estimation formula to find out how many log devspaces one should setup? Is this rule (split the whole data area into several devspaces) also valid for the data area? 6. Is it recommendable to use raw devices (on an UNIX machine) also for log or system devspaces? Thanks in advance! Frank Schimmelpfennig PHILIPS Semiconductors Hamburg ATO-PICTOH IT&DataSupport Tel.: +49 40 5613 -1835, Fax: -3020 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
