indizes: automatic use or activate by query?

[Former Member]

Hi all,

i want to know if i have to activate each index seperate in query ( iE: with (index(abc))) or if the sql server is intelligent enough to chose the correct/needed index by himself?

Thanks and regards, Sabrina

[MarkCulp]

This forum is for questions about SQL Anywhere (not SQL Server!)... but if the question is about SQL Anywhere then my response is: Why would you want to do that? SQL Anywhere is fairly intelligent and it is best to let it decide what indexes to use.

[Breck_Carter]

The key phrase in your question is "if i have to" rather than "how do I".

For SAP SQL Anywhere the answer is no.

For Microsoft SQL Server the answer is no.