BigQuery 表上的索引 [英] Indexes on BigQuery Table
问题描述
我有一个用例，其中我们在 BigQuery 中有几个表.现在我想在 BigQuery 表中的一列上实现索引.但我没有找到足够的文档来做到这一点.我发现一些博客和帖子提到 BigQuery 不支持索引.请帮我找到可以帮助我在 BigQuery 上实现索引的博客或帖子.提前致谢.
I have a use case in which we have a few tables in BigQuery. Now I want to implement an index on one of the columns in the BigQuery table. But I am not finding enough documentation to do that. I found a few blogs and posts mentioning BigQuery doesn't support indexes. Please help me find a blog or post which can help me in implementing index on BigQuery. Thanks in advance.
推荐答案
2019 年更新:查看 c簇可以提高查询时间和扫描数据:
2019 update: Check out how clusters improve your querying times and data scanned:
正如评论中所述，此问题与如果我的数据大 100 倍，BigQuery 将如何处理它".在处理传统数据库时，索引是正确的解决方案，但 BigQuery 有所不同:随着数据规模的增长，BigQuery 会添加更多服务器 - 保持性能几乎不变.
As stated in the comments this question is associated with "how would BigQuery deal with my data if it was a 100 times larger". When dealing with traditional databases an index is the right solution, but BigQuery is different: As data size grows, BigQuery adds more servers to the mix - keeping performance almost constant.
换句话说，随着数据的增长，您应该预期成本会线性增加，而性能几乎保持不变.不需要索引.这也是人们选择 BigQuery 来处理分析工作负载的重要原因之一.
In other words, as your data grows you should expect costs to increase linearly, with performance staying almost constant. No indexes needed. And this is one of the big reasons why people choose BigQuery for their analytical workloads.
(当然，这完全取决于您的具体用例，请测试这些断言并报告！)
(It all depends on your specific use case of course, please test these assertions and report back!)
这篇关于BigQuery 表上的索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
