SQL Server中的索引 [英] Index in Sql Server

问题描述

我有一张桌子，缺少更多记录.我想索引表以查找特定记录.请给我打电话举例.

并且您是否知道abt筛选索引(SQL Server 2008中的新索引)?如果你知道，请给我解释！

感谢

解决方案

查看此 [ ^ ]以了解如何创建索引

使用索引中在where子句或联接条件中使用的列.....
过滤后的索引就像带where子句的索引....当您不希望某类成为空值之类的索引时，它会非常用....这将使索引更快....

Hi frnds,

i have one table with more lacks record. i want to index the table for find particular record. Please tel me with example.

and do u knw abt Filtered Index(new one in sql server 2008)? if u knw please explain me!!!!!


thanks

解决方案

Look at this [^]to see how to create indexes

Use those columns in index which are used in where clause or joinning conditions.....
Filtered index is like index with where clause....its very use full when u dont want somethign to be index like null values....this will make index faster....

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