Recreating SIPS feature in pre-prod

kannan_1

Hi,

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

Thanks...

[Deleted User]

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

Thanks for your reply Eugenia.......

eli_revach

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 !