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.Hard to tell for me, but i think you can use the EXPLAIN statement to check whether SAPDB uses some "hidden" indexes when using a column in the WHERE-clause.
The other things is, that CREATE INDEX should fail if a column is already indexed. So this is the other way to test if a column is already indexed.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
