Arne Gehlhaar wrote: > > I've played around with SAPDB for some time now, and there > are still two > things that the user manual does not really help me with: ... > 2) FOREIGN KEYS and INDEXES. I use Sybase Power Designer for database > design. For some reason, it let's me either use foreign key > constrains > (ref. integrity) XOR build indexes on foreign keys. Does this > make any > sense from SAPDB's point of view? Will indexes on foreign > keys increase > perfomance when joining tables or does SAPDB use foreign keys as > efficiently as primary keys?
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 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
