Recreating SIPS feature in pre-prod


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



  • Options
    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
  • Options
    Thanks for your reply Eugenia.......
  • Options
    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 !

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file