>I have one table with the next structure (partial):
>(
>.
>BASE VARCHAR(8) ASCII,
>.
>FECHA VARCHAR(8) ASCII,
>TABLA VARCHAR(20) ASCII,
>.
>)
>I run: alter table MyTabla add primary key (BASE,TABLA,FECHA).
>When I execute "show primary key of MyTable" through sql studio it show
the
>next structure: "BASE", "TABLA", "FECHA" (is good), but, when I execute
>"catalogextract all" with repmcli the outfile show (wrong!): PRIMARY KEY
>("BASE", "FECHA", "TABLA").
yes, its a bug. it will be fixed in one of the next releases.
>What should be the problem with the order of fields on the primary key?
the odering of primary keys affects the performance of executing sql
commands.
Hans-Georg Bumes
--
Hans-Georg Bumes
SAP DB, SAP Labs Berlin
http://www.sapdb.org/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
