Having foreign key (referential constraints) on a table or not having them
does NOT influence joining of tables.
Foreign keys do NOT create indexes by its own.
To increase performance for foreign keys AND searching of tables
(no matter if join or not) YOU, the user, has to create indexes.
Elke
SAP Labs Berlin
Just as I had expected... Thank you for clarifying that point.
Arne
--
Institute of Shipping Economics and Logistics http://www.isl.org/
Arne Gehlhaar mailto:[EMAIL PROTECTED]
Universitaetsallee GW1 Block A phone:+49.421.22096.49
D-28359 Bremen, Germany fax:+49.421.22096.55
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
