SQL Server如何在缺失索引建议中建议列的顺序 [英] How does SQL Server suggests the order of columns in Missing Index Suggestion

问题描述

嗨大家好

我正在寻找一个理解或算法，它给出了SQL Server 2008/2012中缺失索引建议中列的订单。

如果有的话一个人知道SQL Server使用的是否有任何算法？

需要一些关于此的深层信息，因为我正在处理列的顺序非常关键的部分。

Hi Guys
I am looking for an understanding or an alogorithm that gives the orders of the columns in Missing Index Suggestion in SQL Server 2008/2012.
If any one knows is there any alogrithm that SQL Server uses for it?.
Need some deep information on this as i m working on a part where there order of columns is very critical.

推荐答案

如果订单很重要，您需要一种方法对它们进行排序。如果你不这样做，订单不能保证，因为套装没有订单。



如果无法对它们进行排序，那么订单是随机的没有理由批评。

If order matters, you need a way to sort them. if you don't, order is not guaranteed, because sets do not have an order.

If there's no way to sort them, then the order is random and has no reason to be critical.

这篇关于SQL Server如何在缺失索引建议中建议列的顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！