Disable Projection Temporarily?

[usli06]

Hi,

Can I disable a projection so that it can not be used? I don't want to drop it, just make sure it is not used by a query. I would prefer that another projection set be used during testing.

Thank you

[scutter]

Nope. This has been on my wishlist for years. I think I first submitted a request for this enhancement in oh 2010 .

—Sharon

[NorbertKrupa]

Sharon--How do you go about submitting enhancement requests?

[JimKnicely]

#usli06,

Until we get Sharon's enhancement , maybe you can change your query so that it directly references the projection you want to test instead of the table?

[NorbertKrupa]

I'm sure there has to be a way using the add_vertica_options() function... I mean there's

Code: Select all

add_vertica_options('EE', 'DISABLE_EXPR_ANALYSIS');
add_vertica_options('EE', 'ENABLE_JOIN_SPILL');

It would be nice if we could just pass the hint in the query or use add_vertica_option('EE', 'USE_PROJECTION_01');

[id10t]

Hi!

[DELETED]

[NorbertKrupa]

Wow, that's awesome. I had to write a post about it. Thanks!