查询SQL实例行为 [英] Queries on SQL Instance Behaviour

问题描述

我想了解以下查询的详细信息

1。我们可以在具有大行的表上添加索引（集群/非集群）索引吗？系统会接受 

2。我可以重命名表中已存在的索引。 

---

hemadri

解决方案

回答内联：

1.我们可以添加索引（cluster / non cluster）具有大行的表上的索引。将系统接受 

SS：是的，你可以，但是它总是很好检查你是否还有其他选项，比如如果可能你可以归档不需要的数据。如果你觉得它太大，你也可以考虑分区选项。

2.我可以重命名表中现有的索引。 

SS：是的，你可以。请检查此链接：  https：// docs.microsoft.com/en-us/sql/relational-databases/indexes/rename-indexes?view=sql-server-2017

Hi,

I would like to know the details of the following queries

1. Can we add indexes ( cluster/ non cluster) indexes on a table that has huge rows . will system accept 

2. Can i rename the indexes thats been existing in the table . 

---

hemadri

解决方案

Answer inline:

1. Can we add indexes ( cluster/ non cluster) indexes on a table that has huge rows . will system accept 

SS: Yes you can, however its always good to check if you have other options too, like if you could archived not required data if possible. You may also consider partitioning options if you think its too big.

2. Can i rename the indexes thats been existing in the table . 

SS: Yes you can. Check this link: https://docs.microsoft.com/en-us/sql/relational-databases/indexes/rename-indexes?view=sql-server-2017

这篇关于查询SQL实例行为的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！