Skip to main content

Recreating SIPS feature in pre-prod

  • August 5, 2014
  • 3 replies
  • 14 views
kannan_1
Forum|alt.badge.img+1
Hi,

Is there any way that we can force the optimizer to choose SIPS feature for executing a query.

Thanks...

    3 replies

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • August 5, 2014
    Optimizer will chose SIP every time it can. You cannot force it to use it as it is the default. However, you can disable it, but I think is a directive that you should use under support guidance. 
    HTH, Eugenia
    kannan_1
    Forum|alt.badge.img+1
    • kannan_1
    • Author
    • Participating Frequently
    • August 5, 2014
    Thanks for your reply Eugenia.......
    eli_revach
    Forum|alt.badge.img+2
    • eli_revach
    • Participating Frequently
    • August 17, 2014
    As mention by Eugenia SIP  by  default is enabled , you can disable it using below HINT on your specific query  :

    SELECT /*+add_vertica_options(BASIC,DISABLE_SIPS)*/

    Do not use it in production withour advice with Vertica suport !

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement