DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Does anyone know the functions of those parameters???

  1. #1
    Join Date
    Jul 2000
    Posts
    41
    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

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width