关于 Azure 表二级索引
我知道二级索引还没有： 它在愿望清单中并且“已计划”
我喜欢获得一些关于即将到来的辅助的想法（或来自可靠来源的信息）索引
第一个问题：我注意到MS计划了“辅助索引”：这意味着我们可以在一个表上创建任意数量的索引
第二个问题：当前索引是“PartitionKey+RowKey”，如果上述问题不成立，二级索引是“RowKey+PartitionKey”还是我们有一个好的我们有机会定制它吗？
我喜欢获得一些想法，因为我目前正在设计一个表，因为一开始数据不会太多，所以我想我可以等待二级索引功能，而不需要此时创建多个表。
请分享您的想法或您拥有的任何资源，谢谢。
I know the Secondary Index(s) is not here yet: It's in wish list and "planed"
I like to get some ideas (or information from the reliable source) about the incoming secondary index(s)
1st question: I noticed MS planed "secondary indexes": is that mean we can create as many indexes as we want on one table
2nd question: Current index is "PartitionKey+RowKey", if above question is not true, will the secondary index be "RowKey+PartitionKey" or we have a good chance that we can customize it?
I like to gain some ideas because I am currently design a table, since the data won't much from beginning, so I think I can wait for the secondary index feature without create multiple tables at this moment.
Please share you ideas or any source you have, thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
除了您引用的网站上写的内容之外，目前没有关于二级索引的信息。所以，没有办法回答你的两个问题。
与我合作的几个使用表存储的客户已经采用多表方法来提供额外的索引。对于那些需要广泛索引覆盖的数据，该数据通常已进入 SQL Azure（或 SQL Azure + 表存储的组合）。
There's currently no information on secondary indexes, other than what's written at the site you referenced. So, there's no way to answer either of your two questions.
Several customers I work with, that use Table Storage, have taken the multiple-table approach to provide additional indexing. For those requiring extensive index coverage, that data typically has found its way into SQL Azure (or a combination of SQL Azure + Table Storage).
作为一名 Windows Azure MVP，我没有任何有关表服务中二级索引的信息。如果我们确实需要在表服务中使用更多索引，但不想使用 SQL Azure，（不仅仅是因为定价......）那么我想对我的数据进行非规范化，它将相同的数据拆分为多个数据表，以不同的行键作为索引。
As a Windows Azure MVP I don't have any information about the secondary indexes in table service. If we do need more indexes in table service, but don't want use SQL Azure, (Not just because of the pricing...) then I would like to de-normalization my data, which split the same data into more than one table, with different row key as the indexes.
这个问题现在已经两年了。 Azure 表存储中仍然没有二级索引的迹象。我的猜测是，现在这种情况不太可能发生。
This question is now two years old. And still no sign of secondary indexes in Azure Table Storage. My guess is that it is now very unlikely to ever eventuate.
Azure Cosmos DB 为为 Azure 表存储编写且需要以下功能的应用程序提供表 API：
自动二级索引
来自：Azure Cosmos DB 简介：表 API
因此，如果您愿意将表移至 Cosmos，那么您将获得全部这您可能想要的索引。
Azure Cosmos DB provides the Table API for applications that are written for Azure Table storage and that need capabilities like:
Automatic Secondary Indexing
From: Introduction to Azure Cosmos DB: Table API
So if you are willing to move your tables over to Cosmos, then you will get all the indexing you could ever want.