I am trying to have queries running in a DSS enviroment
run faster. Someone suggested that I should try to set
the following parameters in order to force the use of indexes
using hints. If I set those parameters and run queries
that use optimizer hints to force the use of certain indexes the
queries are completing fast. However, we cannot use optimizer hints all the time and at that time the without using
hints and force use of indexes, the queries are extremely slow.