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.
Can anyone explain the use of those parameters???
Your input will be appreciated.
Check out the articles at http://www.evdbt.com/library.htm (see item number 5 - The Search for Intelligent Life in the CBO) by Tim Gorman.
If you ***really*** want to know, read them, or were you just making polite conversation?
Click Here to Expand Forum to Full Width