Elke,
>If one uses a user-defined primary key for his table, the rows >are sorted according to that primary key and stored in this >sorted form. >--> if the first column of your user-defined primary key would >specify the company, all rows of one company are next to each other, >with no other company-row somewhere in between. I'd nerver thought it would be so easy. Viellen Dank. >--> searching for all data of one company would only read those >pages full of rows of that company. Exactly what I want. >But, please allow the question: >it is necessary to put all the data of all the companies in one >table together? If each company would use its own set of tables >( may be the same name, but owned by different users ) could solve >your problem, too, without that primary-key-column. It is not necessary. Theoretically I could have one database user per company. But there are thousands of those companies. In the event of schema change I'd have to apply it to all users one by one. Or is there a way to have them in sync? Thanks again. Regards, Wojtek _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
