Does anyone know the functions of those parameters???

[cdutta]

Hi everybody,

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???



optimizer_max_permutations
optiimizer_index_caching
optimizer_index_cost_adj
hash_multiblock_io_count


Your input will be appreciated.

Thanks
CD

[stecal]

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?