create index

[Arne Gehlhaar]

Hi,

is it useful or neccessary to create an index on the primary and foreign key columns? I am trying to migrate from Sybase ASE 11.0.3.3 to SAPDB 7.3 and the Power Designer (DataArchitect) creates these indexes by default. I remember reading that SAP DB automatically uses or creates indexes for key columns, but I'm not so sure any more.

Thanks,
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