https://community.sap.com/t5/technology-q-a/when-to-create-indexes/qaa-p/13822707#M4853550 <P>From the <A href="http://dcx.sybase.com/index.html#html/dbugen10/ug-when-using-perform.html" rel="nofollow">SA 10.0.1</A> docs:</P> <BLOCKQUOTE> <P><STRONG>Keys and unique columns</STRONG></P> <P>SQL Anywhere automatically creates indexes on primary keys, foreign keys, and unique columns. You should not create additional indexes on these columns. The exception is composite keys, which can sometimes be enhanced with additional indexes.</P> </BLOCKQUOTE> <P>I guess that pretty says it all.</P> Mon, 14 Jun 2010 16:08:28 GMT VolkerBarth 2010-06-14T16:08:28Z https://community.sap.com/t5/technology-q-a/when-to-create-indexes/qaq-p/13822706 <P>When creating indexes, is it necessary to explicitly define them on Foreign, Primary, and Alternate Keys or are they created by default because of the key?</P> Mon, 14 Jun 2010 14:05:34 GMT https://community.sap.com/t5/technology-q-a/when-to-create-indexes/qaq-p/13822706 Former Member 2010-06-14T14:05:34Z https://community.sap.com/t5/technology-q-a/when-to-create-indexes/qaa-p/13822707#M4853550 <P>From the <A href="http://dcx.sybase.com/index.html#html/dbugen10/ug-when-using-perform.html" rel="nofollow">SA 10.0.1</A> docs:</P> <BLOCKQUOTE> <P><STRONG>Keys and unique columns</STRONG></P> <P>SQL Anywhere automatically creates indexes on primary keys, foreign keys, and unique columns. You should not create additional indexes on these columns. The exception is composite keys, which can sometimes be enhanced with additional indexes.</P> </BLOCKQUOTE> <P>I guess that pretty says it all.</P> Mon, 14 Jun 2010 16:08:28 GMT https://community.sap.com/t5/technology-q-a/when-to-create-indexes/qaa-p/13822707#M4853550 VolkerBarth 2010-06-14T16:08:28Z