Is there a "Force Index" equivalent in Vertica?
Is there a "Force Index" from My开发者_如何学PythonSQL equivalent in Vertica DB?
You can select directly from a projection instead of the table. For instance, instead of
select col from foo;
do this:
select col from foo_p1; -- where table_p1 is a projection of table foo`
精彩评论