开发者

Is there a "Force Index" equivalent in Vertica?

开发者 https://www.devze.com 2022-12-19 13:17 出处:网络
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

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`
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号